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 option. Also >> tried to use

Re: [GENERAL] Accessing DB2 tables from postgresql

2017-06-28 Thread Adrian Klaver
On 06/28/2017 01:28 AM, Swapnil Vaze wrote: Hello, I dropped and recreated foreign table with odbc_database option. Also tried to use import foreign schema object still getting same error. CREATE FOREIGN TABLE odbc_table ( CTGRY_ID INTEGER, CTGRY_CD VARCHAR(10), UPDT_TS TIMESTAMP ) S

Re: [GENERAL] Accessing DB2 tables from postgresql

2017-06-28 Thread Swapnil Vaze
Hello, I dropped and recreated foreign table with odbc_database option. Also tried to use import foreign schema object still getting same error. CREATE FOREIGN TABLE odbc_table ( CTGRY_ID INTEGER, CTGRY_CD VARCHAR(10), UPDT_TS TIMESTAMP ) SERVER odbc_server OPTIONS ( odbc_database 'TE

Re: [GENERAL] Accessing DB2 tables from postgresql

2017-06-27 Thread Adrian Klaver
On 06/27/2017 03:11 AM, Swapnil Vaze wrote: Hello, I am trying to access few table present in DB2 LUW from postgres9.5 database. I have installed unixODBC driver and connection to DB2 is working fine. I have installed CartoDB/odbc_fdw foreign data wrappers. I have user below commands to creat

Re: [GENERAL] Accessing DB2 tables from postgresql

2017-06-27 Thread Achilleas Mantzios
On 27/06/2017 13:11, Swapnil Vaze wrote: Hello, I am trying to access few table present in DB2 LUW from postgres9.5 database. I have installed unixODBC driver and connection to DB2 is working fine. I have installed CartoDB/odbc_fdw foreign data wrappers. I have user below commands to create for