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 <CREATE TABLE "A90DVDT"."DLR_FAM_MRKTSHR_FY_END"
> at ./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)
);
Thanks,
Swapnil
On Tue, Dec 6, 2016 at 12:23 PM, Julien Rouhaud <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
