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
