Re: [GENERAL] Accessing DB2 tables from postgresql

2017-07-03 Thread Swapnil Vaze
Hello, Thanks for help!! I am following up on that existing thread. Thanks, Swapnil Vaze On Wed, Jun 28, 2017 at 7:01 PM, Adrian Klaver wrote: > On 06/28/2017 01:28 AM, Swapnil Vaze wrote: > >> Hello, >> >> I dropped and recreated foreign table with odbc_database opti

Re: [GENERAL] Accessing DB2 tables from postgresql

2017-06-28 Thread Swapnil Vaze
TA WRAPPER odbc_fdw OPTIONS (dsn 'TESTV9'); To test for other DBMS, I created foreign object for postgres with odbc_fdw, however it is throwing too long encoding error. Does ODBC wrapper support DB2 access? Thanks, Swapnil Vaze On Tue, Jun 27, 2017 at 6:38 PM, Adrian Klaver wrote: > O

[GENERAL] Accessing DB2 tables from postgresql

2017-06-27 Thread Swapnil Vaze
able 'table1' ); All commands work fine, however when I try to select data from table it throws error: $ select * from odbc_table; ERROR: Executing ODBC query Can anyone help me here? How can I access DB2 LUW or zOS database tables from postgres? -- Thanks & Regards, Swapnil Vaze

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

2016-12-06 Thread Swapnil Vaze
; 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 wrote: > On T

[GENERAL] Migrating data from DB2 zOS to PostgreSQL

2016-12-05 Thread Swapnil Vaze
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? -- Thanks & Regards, Swapnil Vaze