Trying to run a DB2 UDB iSeries "Create Table" script in DB2 Express-C and I get the following error message: An unexpected token "37" was found following".
CREATE TABLE C0228301.A_PMDRESP (
PRSSNID CHAR(32) CCSID 37 NOT NULL DEFAULT '' ,
PRMEDIACD CHAR(15) CCSID 37 NOT NULL DEFAULT '' ,
PRMQF NUMERIC(5, 0) NOT NULL DEFAULT 0 ,
PRRSPNO NUMERIC(3, 0) NOT NULL DEFAULT 0 ,
PRRSPCBOX CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
PRPROCSTAT CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
PRINQNO NUMERIC(10, 0) NOT NULL DEFAULT 0 )
RCDFMT APMDRESPF ;
How do I fix this?
Pinned topic From DB2 UDB iSeries to DB2 Express-C
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-08-17T06:51:09Z at 2012-08-17T06:51:09Z by bluey01
SystemAdmin 110000D4XK5837 Posts
Re: From DB2 UDB iSeries to DB2 Express-C2012-07-27T06:29:34ZThis is the accepted answer. This is the accepted answer.Hello Christina,
The only values supported for keyword CCSID are ASCII or UNICODE.
HRFM_Christina_Gregory 270005HRFM2 Posts
Re: From DB2 UDB iSeries to DB2 Express-C2012-07-31T15:53:33ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
Thanks for the response. Unfortunately, I'm not familiar with IBM DB2. So how do I set up DB2 to ensure it interprets characters correctly?
bluey01 110000ENQX10 Posts
Re: From DB2 UDB iSeries to DB2 Express-C2012-08-17T06:51:09ZThis is the accepted answer. This is the accepted answer.
- HRFM_Christina_Gregory 270005HRFM
You could aslo install IBM DataMovement Tool - this will generate the tables and also allow you to transfer the data as well. And its free!
You can install DataStudio and connect to the iSeries with that and Generate DDL from within Data Studio - then you can connect to an LUW database and run it - without having to leave the tool