IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
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: 7309
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: 6966
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: 765
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
No new posts Monitoring production job progress. N... JCL & VSAM 4
Search our Forums:

Back to Top