MQSeries.net :: View topic

Gama · Posted: Tue Jan 11, 2005 6:03 am Post subject:

Hi all,
i'm using WMQI v2.1 and i want to use the ESQL do make a select on a database involving 2 tables, but the WMQI return an error.
The select is:
SET Environment.Variables."SYS_MSG"[] = (SELECT Cc.MSG_CLIENT, T.MSG_TYPE FROM Database.ITG_SYS_MSG as T, Database.ITG_SYS_MSG_CHECK as Cc WHERE CAST(T.MSG_ID as CHARACTER) = CAST("InputRoot"."MQMD"."MsgId" as CHARACTER) AND T.ID = Cc.MSG_ID );

the error return is:
...
RecoverableException BIP2519E: (1, 1) : Error executing SQL statement 'SELECT Cc.MSG_CLIENT, T.MSG_TYPE, T.MSG_ID FROM ITG_SYS_MSG TITG_SYS_MSG_CHECK Cc WHERE (T.ID)=(Cc.MSG_ID)' against datasource 'COTEDITG' with parameters ''.
The following error occurred during execution of a database SQL statement against datasource 'COTEDITG'. The SQL statement was 'SELECT Cc.MSG_CLIENT, T.MSG_TYPE, T.MSG_ID FROM ITG_SYS_MSG TITG_SYS_MSG_CHECK Cc WHERE (T.ID)=(Cc.MSG_ID)'. The parameters passed were ''.
DatabaseException BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.
DatabaseException BIP2322E: Database error: SQL State '42601'; Native Error Code '-104'; Error Text '[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "Cc" was found following "G TITG_SYS_MSG_CHECK". Expected tokens may include: "<space>". SQLSTATE=42601
'.
The error has the following diagnostic information: SQL State '42601' SQL Native Error Code '-104' SQL Error Text '[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "Cc" was found following "G TITG_SYS_MSG_CHECK". Expected tokens may include: "<space>". SQLSTATE=42601
'
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
...

Can anybody tell me want i'm doing wrong.
Thanks in advance.