Thanks Roger. I was just in the process of looking at my HDECP data block.
The field DECPAPSC is set to UNICODE. I guess the previous DB2 systems I
was working on had tha set to EBCDIC, or there was a translation somewhere
along the path to the PREPARE. I'll try it.
--Dave
----- Original Message -----
From: "Roger Bowler" <[email protected]>
Newsgroups: bit.listserv.ibm-main
To: <[email protected]>
Sent: Friday, January 20, 2012 10:38 AM
Subject: Re: Help with a DB2 error -104 on previously working sql stmt
On Thu, 19 Jan 2012 12:34:17 -0600, Dave Day <[email protected]>
wrote:
This sql worked at Dallas on DB2 version 8, but I am getting sql
code -104
when I run it on my zPDT against DB2 version 9. When I run a PREPARE for
the following text, I get the -104.
INSERT INTO DAD0001.ASMSRCZR VALUES(?,?,?,?,?,?)
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL " ". SOME SYMBOLS THAT
MIGHT BE LEGAL ARE: <ERR_STMT> <WNG_STMT> GET SQL SAVEPOINT HOLD FREE
ASSOCIATE CALL
Something changed between what my DB2 version 9 system expects and
what my DB2 verstion 8 system had st up
Try rerunning the BIND with ENCODING(EBCDIC) specified as an additional
parameter. It worked for me.
Roger Bowler
Hercules "the people's mainframe"
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
