By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

Control Center Error

P: n/a
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_top>". 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_top>". SQLSTATE=42601
Can you help me??
Thanks
Mar 31 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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_top>". 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_top>". SQLSTATE=42601

Please post the failing statement as well.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 31 '06 #2

P: n/a
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_top>". 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_top>". SQLSTATE=42601

Please post the failing statement as well.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Mar 31 '06 #3

P: n/a
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_top>". 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_top>". 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
Mar 31 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.