I know there is a DB2 list, but thought maybe I could get an answer here in
less time. Prior to acquiring a zPDT I was running on the IBM Dallas RDP
system. On that system I had some sql that ran against DB2 version 8. When I
moved from Dallas to my zPDT, I brought up DB2 version 9. As part of my
testing, I have some sql that is there just to generate some DB2 activity.
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(?,?,?,?,?,?)
The table DAD0001.ASMSRCZR has just previously been created with 6 columns.
The DDL to create that ran successfully. The PREPARE for the above text
string used to work, but now get the -104. When I run the SQLCA thru DSNTIAR,
I get the following. Between the two quote marks is a space/blank.
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, but I don't have a clue at this point. Anyone
who could help with this, I would appreciate it. I am in the DB2 books right
now, but haven't hit anything that explains this behavior. Thanks in advance
for any help.
--Dave Day
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
