deepag02
New User
Joined: 23 Jul 2007 Posts: 20 Location: India
|
|
|
|
HI,
In one of my COBOL-DB2 programs, i am trying to run a dynamic multi row fetch cursor using SQLDA. But i am gettting -804 sqlcode.
PFB the sql queries.
EXEC SQL
PREPARE S1 FROM :WS-DSTRING
END-EXEC
SQLCODE AFTER PREPARE +000
EXEC SQL
DESCRIBE S1 INTO :SQLDA
END-EXEC
DESCRIBE SQLCODE +000
on displaying SQLTYPE in binary format:
WS-SQLTYPE = 10000
WS-SQLTYPE 20000
EXEC SQL
DECLARE CUSTCUR CURSOR
WITH ROWSET POSITIONING FOR S1
END-EXEC
DECLARE CURSOR SQLCODE +000
COMPUTE SQLDABC = 104
COMPUTE SQLN = 2
EXEC SQL
OPEN CUSTCUR
END-EXEC
EXEC SQL
FETCH NEXT ROWSET FROM CUSTCUR FOR 1 ROWS
USING DESCRIPTOR :SQLDA
END-EXEC
WS-SQLCODE -000804
WS-SQLSTATE07002
using diagnostics :
WS-MESSAGE-TEXTAN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE SQL STATEMENT, REASON 16
which means
"Unrecognized output data type".
Please let me know if the SQLTYPE needs to be changed, from what i understand it should be obatined my means of DESCRIBE itself. And is SQLTYPE = 16 (decimal of 10000 binary) a valid value? since i dont see that code in the manuals. |
|