468,257 Members | 1,427 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

Control Center Error

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
3 1933
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
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
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.

Similar topics

1 post views Thread by Sean C. | last post: by
6 posts views Thread by Franco Lombardo | last post: by
11 posts views Thread by trinitypete | last post: by
2 posts views Thread by tshad | last post: by
8 posts views Thread by bienwell | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.