MVSFORUMS.com

tejas · Beginner Joined: 12 Mar 2003 Posts: 3 Topics: 1

Dear all

i have got one error SQL30020N after firing db2 query
Reason code 124C-00
SqlState 58009

This error i have got after firing simple select sql which has IN statement.
I do not have any other information to share.

Can somebody please tell me what could be possible reason ?

kolusu · Posted: Wed Mar 12, 2003 10:45 pm Post subject:

Tejas,

The reason code = X'124C ' means you have a Syntax Error Code (SYNERRCD) . Check your sql syntax and re run the query. or post the sql query in here and we may take a look at it

Hope this helps...

cheers

kolusu

tejas · Beginner Joined: 12 Mar 2003 Posts: 3 Topics: 1

Deal kolusu

thanks a lot for the reply

i have a very simple query... as it is like this
select DISINXCD as typeCodeNo, DISKMKMJ AS contractStatus
FROM TBRA0990
where DISINXCD in ( "+Codes+")

where codes is a variable which will have comma seperated values

thanks in advance

bye

kolusu · Posted: Sat Mar 15, 2003 8:37 am Post subject:

Teja,

Why is there is a + character used before the codes?? Are you using it as an escape character. If so then you should have 2 ++ or +_ . But The escape character + sign is used in the like predicate.

Kolusu

tejas · Beginner Joined: 12 Mar 2003 Posts: 3 Topics: 1

select DISINXCD as typeCodeNo, DISKMKMJ AS contractStatus
FROM TBRA0990
where DISINXCD in ( "+Codes+")

where codes is a java variables which contains comma separated values
for eg. after running the java file i normally
get following sql in log file

select DISINXCD as typeCodeNo, DISKMKMJ AS contractStatus
FROM TBRA0990
where DISINXCD in ( '10', '20', '30')

gotluru · Beginner Joined: 17 Dec 2002 Posts: 29 Topics: 6

Hi Teja,

Try Declaring your linkage section like this: