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?
This topic has been locked.
3 replies Latest Post - 2012-08-17T06:51:09Z by bluey01
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 PostsACCEPTED ANSWER
Re: From DB2 UDB iSeries to DB2 Express-C2012-07-27T06:29:34Z in response to HRFM_Christina_GregoryHello Christina,
The only values supported for keyword CCSID are ASCII or UNICODE.
HRFM_Christina_Gregory 270005HRFM2 Posts
bluey01 110000ENQX10 PostsACCEPTED ANSWER
Re: From DB2 UDB iSeries to DB2 Express-C2012-08-17T06:51:09Z in response to HRFM_Christina_GregoryThere are a couple of ways of gettnig the script from the iSeries. If you aer using iSeries Navigator, then right click onthe tables and Generate SQL and under the options tab, select ANSI/ISO. THis will give you the basix SQL that will run on DB2 LUW.
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