View previous topic :: View next topic
|
Author |
Message |
kishpra
New User
Joined: 24 May 2010 Posts: 92 Location: Pune
|
|
|
|
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 |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Did you try to execute the query in SPUFI?? |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
kishpra
New User
Joined: 24 May 2010 Posts: 92 Location: Pune
|
|
|
|
i ran the query in Spufi and it ran fine. |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
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 |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
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 |
|
|
|