IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Sql Code -204, please help


 
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: :: View next topic  
Author Message
kishpra

New User


Joined: 24 May 2010
Posts: 92
Location: Pune

PostPosted: Fri Aug 02, 2013 4:32 pm
Reply with quote

Hi ,

In one of my prog, I am getting -204 at the below query -

STRING
'INSERT INTO TWCCA11 ' DELIMIOTED BY SIZE
'SELECT * FROM TDWCA11 ' DELIMITED BY SIZE
'WHERE CSNO = ?' DELIMITED BY SIZE
'AND CSTYP = ?' DELIMITED BY SIZE
INTO CSE-IRT-T
END-STRING
MOVE LENGTH OF(CSE-IRT-T) TO CSE-IRT-L
EXEC SQL
PREPARE CSE_INSERT FROM :CSE-IRT
END-EXEC

var def -
05 CSE-IRT
49 CSE-IRT-L PICS9(4) COMP.
49 CSE-IRT-T PIC X(150).
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1566
Location: Andromeda Galaxy

PostPosted: Fri Aug 02, 2013 4:43 pm
Reply with quote

Did you try to execute the query in SPUFI??
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Fri Aug 02, 2013 4:54 pm
Reply with quote

You have typed. We don't want to look at your typos and "solve" those first. Please paste from your emulator, and use the Code tags, which preserve spacing.

Do you have trailing blanks on each literal (except the last)?

When you use LENGTH OF, are you expecting a result of 150 each time?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Fri Aug 02, 2013 5:00 pm
Reply with quote

since a -204 means that the db2 object to which you are refering is not defined to the db2 system.

i would guess that TWCCA11 (and TDWCA11) needs to be better qualified,
all of which you would have known,
had you bothered to look-up the -204 sql code.

and if you do not understand what is meant by qualification,
READ the manual.

also, since this is a db2 question, i am moving it to db2 and out of COBOL
Back to top
View user's profile Send private message
kishpra

New User


Joined: 24 May 2010
Posts: 92
Location: Pune

PostPosted: Fri Aug 02, 2013 5:14 pm
Reply with quote

i ran the query in Spufi and it ran fine.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Fri Aug 02, 2013 7:00 pm
Reply with quote

kishpra wrote:
i ran the query in Spufi and it ran fine.

Then continue to run it in SPUFI (assuming that you really mean SPUFI and not DSNTEP2/4). Mr. Brenholtz has given you the solution; you do not wish to apply it.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 692
Location: Whitby, ON, Canada

PostPosted: Sat Aug 03, 2013 3:04 am
Reply with quote

Akatsukami wrote:
kishpra wrote:
i ran the query in Spufi and it ran fine.

Then continue to run it in SPUFI (assuming that you really mean SPUFI and not DSNTEP2/4). Mr. Brenholtz has given you the solution; you do not wish to apply it.

I always find it a little bit scary when someone with so little apparent DB2 experience tries to mess with an advanced technique like dynamic SQL in a Cobol program. But maybe I am just getting a bit conservative in my old age.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts JCL for replacing code in Cobol JCL & VSAM 8
No new posts Easytrieve EZABX007 with error code 0... CA Products 7
This topic is locked: you cannot edit posts or make replies. VSAM I/O - Extended Addressability - ... JCL & VSAM 12
No new posts Force a Return Code and print error m... SYNCSORT 30
No new posts trying to set return code in PROC JCL & VSAM 15

Back to Top