SQLCODE -104 during runing of program

shreejita · New User Joined: 16 Aug 2009 Posts: 60 Location: chennai

Hi,

I am using dynamic SQL in COBOL-DB2 program and following are the declaration made in program.

01 US.
49 US-LEN PIC S9(4) COMP.
49 US-TEXT PIC X(80).

PROCEDURE DIVISION.

MOVE 40 TO US-LEN.
ACCEPT US-TEXT.

EXEC SQL
EXECUTE IMMEDIATE :US
END-EXEC.

I am accepting US-TEXT , the SQL statement as sting from SYSIN DD * as like this

//SYSIN DD *
'DELETE FROM tbname WHERE EMPCD = "A002" '
/*

i am getting SQLCODE -104 during runing of program and checked with manual saying that it is sysntax error.

Please solve this.

dbzTHEdinosauer · Posted: Wed May 19, 2010 4:47 pm

display your complete sqlca message, which will inidicate which token db2 has decided to flag as in error.

having no idea how you are executing your program,
the connect that has been/not been made,
it could simply be the qualification fo your tbname.

-104 is a rather specific type of 'syntax' error....................

shreejita · New User Joined: 16 Aug 2009 Posts: 60 Location: chennai

i changed the quotes like this

//SYSIN DD *
'DELETE FROM EMPI WHERE EMPCD = 'A002''
/*

Now i am receiving SQLCODE -010 which says string not terminated properly

what z the meaning of that

GuyC · Posted: Wed May 19, 2010 5:18 pm

why do you have quotes around the whole statement ?
try this :

//SYSIN DD *
DELETE FROM EMPI WHERE EMPCD = 'A002'
/*

or

//SYSIN DD *
DELETE FROM EMPI WHERE EMPCD = "A002"
/*

depending on your settings

shreejita · New User Joined: 16 Aug 2009 Posts: 60 Location: chennai

Thanks ALL, It is working now.