Re: [GENERAL] Migrating data from DB2 zOS to PostgreSQL

We have recently done something similar - Converting Informix zLinux to Postgres x86_64.Short answer - We used unloads to put out csv files, wrote some python programs to cleanup data, thenimported them into our Postgres instance ...Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jack

Re: [GENERAL] Migrating data from DB2 zOS to PostgreSQL

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, > wrote: > > > Hello Julien, > > We created DDLs fr

Re: [GENERAL] Migrating data from DB2 zOS to PostgreSQL

On Tue, 6 Dec 2016, 9:27 p.m. Swapnil Vaze, wrote: > > Hello Julien, > > We created DDLs from DB2 zOS system and tried to run script in below > format: > > ./db2topg.pl -f sql1.txt -o testdir > > It throws below error: > > I don't understand > at ./db2topg.pl line 880, line 24. > > For testing

Re: [GENERAL] Migrating data from DB2 zOS to PostgreSQL

Hello Julien, We created DDLs from DB2 zOS system and tried to run script in below format: ./db2topg.pl -f sql1.txt -o testdir It throws below error: I don't understand at ./db2topg.pl line 880, line 24. For testing we used file with below content: cat sql1.txt -- This CLP file was created

Re: [GENERAL] Migrating data from DB2 zOS to PostgreSQL

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/dal