SqlDbx Forum

SqlDbx

You are not logged in.

#1 2011-03-10 14:01:51

DIBITU
Guest

SqlDbx bugs

In my version of SqlDbx I can't use comments and nobody can help me.
Whatever I use to comment a line: two dashes (--) or /*...*/ I get this message:
SQL0104N  An unexpected token "<END-OF-STATEMENT>" was found following "".  Expected tokens may include:  "( + * - ? : CASE CAST USER <FLOAT> CURRENT NEXTVAL".  SQLSTATE=42601
At the same time, all my coworkers using SqlDbx are OK with this.
I don't see any difference between our SqlDbx setups
Please HELP!

#2 2011-03-11 00:22:21

sqldbxhelp
Administrator

Re: SqlDbx bugs

What database and version you connect to?
Can you provide sample statement which has issue.

Offline

#3 2011-04-05 11:18:09

DIBITU
Guest

Re: SqlDbx bugs

DB2 Verison 8
Sql DbxVersion 3.32
Example:
SELECT *                 
   FROM DBPROD.PMSV0100   
   WHERE BR_ID = ' SS'   
-- AND ACCT_NUM = ' 15584'
   AND SEC_ID = '4902P0'
Stops at --

In fact, it perfectly works for my coworkers using exactly the same software versions

#4 2011-04-06 20:23:39

sqldbxhelp
Administrator

Re: SqlDbx bugs

This is a known issue with some versions of DB2. What is strange that only you affected by this.
Do you connect to the same database with the same version of client.
Also is it LUW or z/OS and what Fix Pack level.

Offline

Board footer

Powered by FluxBB