[GENERAL] Accessing DB2 tables from postgresql
| От | Swapnil Vaze |
|---|---|
| Тема | [GENERAL] Accessing DB2 tables from postgresql |
| Дата | |
| Msg-id | CABWf+yQhFNPuTHdB0t3L9D+FWaU5UvNTvYT2hbZFo8r2SVf1cg@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: [GENERAL] Accessing DB2 tables from postgresql
Re: [GENERAL] Accessing DB2 tables from postgresql |
| Список | pgsql-general |
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 foreign table:
$ create extension odbc_fdw;
$ CREATE USER MAPPING FOR postgres SERVER odbc_server_db2 options(odbc_UID '<username>', odbc_PWD '<password>');
$ CREATE FOREIGN TABLE odbc_table (CTGRY_ID INTEGER, CTGRY_CD VARCHAR(10),UPDT_TS TIMESTAMP) SERVER odbc_server_db2 OPTIONS (database 'TESTV9', schema 'schema1', table '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
В списке pgsql-general по дате отправления: