Hi all,
I have a problem when I try to open the tables list on a database.
I work with 8.2.0 Enterprise Edition.
The control center return this error:
[IBM][CLI Driver][DB2/NT] SQL0104N E' stato trovato un token "SELECT
TabSchema, Tabname, Type, T" non previsto dopo "BEGIN-OF-STATEMENT". I token
previsti possono comprendere: "<query_expr_to p>". SQLSTATE=42601
In english sounds like "an invalidi token "SELECT TabSchema, Tabname, Type,
T" is found after "BEGIN-OF-STATEMENT". The correct token can be
"<query_expr_to p>". SQLSTATE=42601
Can you help me??
Thanks 3 2126
scoffer wrote: Hi all,
I have a problem when I try to open the tables list on a database. I work with 8.2.0 Enterprise Edition.
The control center return this error:
[IBM][CLI Driver][DB2/NT] SQL0104N E' stato trovato un token "SELECT TabSchema, Tabname, Type, T" non previsto dopo "BEGIN-OF-STATEMENT". I token previsti possono comprendere: "<query_expr_to p>". SQLSTATE=42601
In english sounds like "an invalidi token "SELECT TabSchema, Tabname, Type, T" is found after "BEGIN-OF-STATEMENT". The correct token can be "<query_expr_to p>". SQLSTATE=42601
Please post the failing statement as well.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
The SQL that the control center try to execute is:
SELECT TabSchema, TabName, Type, TBSpace, INDEX_TBSPACE, LONG_TBSPACE,
DataCapture, Definer, Remarks FROM SYSCAT.Tables WHERE Type in
('T','S','U','H ') ORDER BY TabName FOR FETCH ONLY WITH UR
If i try to execute it from command center the sql runs without problem.
If I open the same database with a control center installed on another
machine i don't receive the error.
Is very strange, but I can't reinstall the DB2 'cause I have a database that
have a dimension of 100GByte!!
Do you have an idea??
"Serge Rielau" <sr*****@ca.ibm .com> ha scritto nel messaggio
news:49******** ****@individual .net... scoffer wrote: Hi all,
I have a problem when I try to open the tables list on a database. I work with 8.2.0 Enterprise Edition.
The control center return this error:
[IBM][CLI Driver][DB2/NT] SQL0104N E' stato trovato un token "SELECT TabSchema, Tabname, Type, T" non previsto dopo "BEGIN-OF-STATEMENT". I token previsti possono comprendere: "<query_expr_to p>". SQLSTATE=42601
In english sounds like "an invalidi token "SELECT TabSchema, Tabname, Type, T" is found after "BEGIN-OF-STATEMENT". The correct token can be "<query_expr_to p>". SQLSTATE=42601 Please post the failing statement as well.
Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab
scoffer wrote: The SQL that the control center try to execute is:
SELECT TabSchema, TabName, Type, TBSpace, INDEX_TBSPACE, LONG_TBSPACE, DataCapture, Definer, Remarks FROM SYSCAT.Tables WHERE Type in ('T','S','U','H ') ORDER BY TabName FOR FETCH ONLY WITH UR
If i try to execute it from command center the sql runs without problem.
If I open the same database with a control center installed on another machine i don't receive the error.
Is very strange, but I can't reinstall the DB2 'cause I have a database that have a dimension of 100GByte!!
Do you have an idea??
"Serge Rielau" <sr*****@ca.ibm .com> ha scritto nel messaggio news:49******** ****@individual .net...
scoffer wrote:
Hi all,
I have a problem when I try to open the tables list on a database. I work with 8.2.0 Enterprise Edition.
The control center return this error:
[IBM][CLI Driver][DB2/NT] SQL0104N E' stato trovato un token "SELECT TabSchema, Tabname, Type, T" non previsto dopo "BEGIN-OF-STATEMENT". I token previsti possono comprendere: "<query_expr_to p>". SQLSTATE=42601
In english sounds like "an invalidi token "SELECT TabSchema, Tabname, Type, T" is found after "BEGIN-OF-STATEMENT". The correct token can be "<query_expr_to p>". SQLSTATE=42601 Please post the failing statement as well.
Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab
I cannot help you with the Control Center error - but installing or
reinstalling DB2 has nothing do to with your database ... as long as you
know where your database is catalogued your should be able to reinstall
DB2 and then simply recatalog your database. Reinstalling does not drop
or remove your database. It simply would remove the entry in the system
catalogue directory (since a new one would be created).
Bob This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Sonu K Mehrotra |
last post by:
mysql server is <172.16.27.39> running on Linux 9.1
I have installed mysql control center (client GUI) on 172.16.27.252
running on Windows 2000 advanced server
The machines are connected in LAN
When I open the
start>programs>mysql control center>mysql control center
to register the server
|
by: Sean C. |
last post by:
Helpful folks,
I have recently migrated our test server, which runs Win NT 4, from
V7.2 FP11 to V8.1.3. Just about everything works wondefully, except I
am having major problems getting the previously defined federated
servers/nicknames to work. But I will start a different thread about
that problem. I thought I'd ask about the less critical problem first.
It deals with the Control Center and the following error:
SQL0713N The...
|
by: Franco Lombardo |
last post by:
Hi all,
I'm running DB2 8.1.5 on Windows 2000 professional SP4.
When I try to start Control Center, I see the splash
screen for a while, then it closes and nothing else happens.
It happens with "Activity center" (Since I'm running the
italian version, I don't know the
english name of this tool, I mean db2tc.bat).
|
by: trinitypete |
last post by:
Hi all,
I have a user control that uses control literal to build
a heading with a link, and a div containing links below.
As the link heading is hit, I want to change the style of
the div, making it visible or not. Yep you guessed it,
expanding tree type functionality.
The header has an onclick event onclick='Doexpandcollapse
|
by: Lauchlan M |
last post by:
Hi.
I have an ASP.net project that works fine.
I copied it to another project using the following steps:
<<
(i) create a new VS.NET ASP.NET project.
| |
by: tshad |
last post by:
This is related to my other Hiding datalistitems problem that I can't seem
to solve.
I have tried different methods which all seem to work only partially.
I decided to try to use a User Control (which I'm sure is not done
correctly) and get errors as I try to execute it.
What I want to do is take all the data from between the ItemTemplate tags
and put a control there. The I hope to be able to hide all the user
|
by: bienwell |
last post by:
Hi,
I have a problem of displaying data bound by a datalist control. In my
table, I have a field Start_date which has Short Date data type. I tried to
update this field by Current Date. After that, I display End_Date on the
DataList control. The output looks like 3/18/2005 12:00:00 AM . I'd
like to format data for this field to be 3/18/2005. Please help me.
Thanks in advance....
|
by: Hoku |
last post by:
I am using dual monitors on a dual head ATI AGP4x video card. I installed the
Nov 11 2005 release of ATI's catalyst control center with Hydravision to
manage the dual monitor setup. I recently updated to .NET v2 and run Zone
Alarm Internet Sec Suite 2006 for firewall and av.
When I log off/shut down the computer a dialog box appears as follows:
End program-.NET-BroadcastEventWindow .1.0.5...
Shutdown hangs up and I must click End Now...
|
by: Yoav |
last post by:
Hello,
I have been trying to enter SQL statmenbts to DB2 control center command line.
I saw that user "Thames" wrote to you:
> I have to repost my question for help.
>
> Yesterday I set up two DB UDB ESE V8.2 server on linux and windows
> platform, respectively. Both servers have been connected without any
> problems
> However, It gave me such error when I tried to make db connection via
> command prompt(windows)
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |