Please, file these as issues on github (i'm the author). It will be much easier to solve your problems. Regards On 06/12/2016 11:42, Sameer Kumar wrote: > > > On Tue, 6 Dec 2016, 9:27 p.m. Swapnil Vaze, <swapvaze28@xxxxxxxxx > <mailto:swapvaze28@xxxxxxxxx>> wrote: > > > Hello Julien, > > We created DDLs from DB2 zOS system and tried to run script in below > format: > > ./db2topg.pl <http://db2topg.pl> -f sql1.txt -o testdir > > It throws below error: > > I don't understand <CREATE TABLE "A90DVDT"."DLR_FAM_MRKTSHR_FY_END" > > at ./db2topg.pl <http://db2topg.pl> line 880, <IN> line 24. > > For testing we used file with below content: > > cat sql1.txt > -- This CLP file was created using DB2LOOK Version "10.5" > -- Timestamp: Tue Dec 6 04:14:28 CST 2016 > -- Database Name: DB239 > -- Database Manager Version: DB2 Version 11.1.0 > -- Database Codepage: 1208 > > > ------------------------------------------------ > -- DDL Statements for Table "A90DVDT"."DLR_FAM_MRKTSHR_FY_END" > ------------------------------------------------ > > CREATE TABLE "A90DVDT"."DLR_FAM_MRKTSHR_FY_END" > ( > "DEALER_ID" CHAR(6) NOT NULL , > "MKTSHR_MONTH" DATE NOT NULL , > "L12_DP_DLR_IN_AOR" DECIMAL(15,6) , > "L12_DP_DLR_OUT_AOR" DECIMAL(15,6) , > "L12_DP_DLR_SHARE" DECIMAL(8,5) , > "L12_SA_DLR_SHARE" DECIMAL(8,5) , > "L12_CA_DLR_SHARE" DECIMAL(8,5) , > "L12_U90_DLR_IN_AOR" DECIMAL(15,6) , > "L12_U90_DLR_OUT_AOR" DECIMAL(15,6) , > "L12_U90_DLR_SHARE" DECIMAL(8,5) > ); > > > I will strongly recommend removing the quotes around table name and > column names. Else you may have challenges porting application to PG. As > PG by default refers to object names in small case unless you out quotes > around them. > > So after migration a statement like > > Select * from DLR_FAM_MRKTSHR_FY_END; > > would fail. > > Also about the error, see what is before this create table statement. > Make sure there is a semi colon to terminate the statement before the > CREATE table. > > How are you running it? psql? > > > Thanks, > Swapnil > > > On Tue, Dec 6, 2016 at 12:23 PM, Julien Rouhaud > <julien.rouhaud@xxxxxxxxxx <mailto:julien.rouhaud@xxxxxxxxxx>> wrote: > > On Tue, Dec 06, 2016 at 11:06:12AM +0530, Swapnil Vaze wrote: > > Hello, > > > > Hello > > > We need some help on how we can migrate data from DB2 zOS database to > > postgres database. > > > > Are there any utilities present? Any thoughts how we should approach? > > You can use this utility: https://github.com/dalibo/db2topg > > The README should provide all needed informations. > > -- > Julien Rouhaud > http://dalibo.com - http://dalibo.org > > > > > -- > Thanks & Regards, > Swapnil Vaze > > -- > > -- > > Best Regards, > > *Sameer Kumar | DB Solution Architect* > > *ASHNIK PTE. LTD.* > > 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533 > > T: +65 6438 3504 | www.ashnik.com <http://www.ashnik.com/> > > Skype: sameer.ashnik | T: +65 8110 0350 > > > ** > > www.ashnik.com <http://www.ashnik.com/> > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
