Re: Migrating data from DB2 zOS to PostgreSQL - Mailing list pgsql-general

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@gmail.com
> <mailto:swapvaze28@gmail.com>> 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@dalibo.com <mailto:julien.rouhaud@dalibo.com>> 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/>​
>