Sequence as column name in DB2 V8 on MVS

shelkesanty · #1 (**permalink**) 09-27-07, 16:28

I am running my application on Windows.
Developed in C++.

The DB2 V8 database is installed on MVS mainframes.

Currently i am getting error as follows :
************************************************** ***************************
Insert into SANS.log(sequence,subsequence,recordTypt,logDate,n ame,action) values (:sequene, :subsequence, :recordType, :logDate, :name, :action)

Class: DBMS
Native Error Code: -199

[IBM][CLI Driver][DB2]SQL0199N The use of the reserved word "SEQUENCE" following "" is not valid. Expected Tokens may include "( SELECT"/ SQLSTATE=42601
************************************************** ***************************

please update me regarding this issue....

thanks.

n_i · #2 (**permalink**) 09-27-07, 17:37

Quote:

Originally Posted by shelkesanty

please update me regarding this issue....

Code:

update you set advice='Read the error message' where regarding='this issue'

Seriously though, try quoting the offending column name:

Code:

Insert into SANS.log("SEQUENCE", ...

Note the uppercase: if you quote an object name it becomes case sensitive.

stolze · #3 (**permalink**) 09-29-07, 12:58

Alternatively: move to V9 (if possible). The V9 SQL parser is more case-sensitive and detects that you are specifying columns names there and allows reserved words.

Btw, this would be syntactically correct SQL but not all DBMS can parse this successfully:

Code:

SELECT SELECT SELECT, FROM FROM
FROM   FROM FROM
WHERE  WHERE = WHERE

Internet Services

Web Development

Digital Marketing

Consumer Tech