Re: [GENERAL] DBlink, postgres to DB2

2014-10-30 Thread Craig Ringer
On 10/22/2014 06:45 PM, Postgres India wrote: > Hi, > I am trying to connect DB2 from postgres using dblink, is there any > configuration required at DB2 and postgres server. You'll need dbi-link (which uses Perl's DBI drivers) or a foreign data wrapper. dblink is for connections between Postgre

Re: [GENERAL] DBlink, postgres to DB2

2014-10-30 Thread Devrim Gündüz
Hi, On Thu, 2014-10-30 at 00:47 -0700, Postgres India wrote: > configure: error: odbc_config not found (required for unixODBC build) I think you need to install unixODBC-devel rpm via yast. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com Postgr

Re: [GENERAL] DBlink, postgres to DB2

2014-10-30 Thread Pavel Stehule
2014-10-30 8:47 GMT+01:00 Postgres India : > Hi , > > While i try to install psqlDDBC, i get this error , i have SUSE Linux > Enterprise Server 11 , trying to find a solution still have no idea. > > ./configure > checking for a BSD-compatible install... /usr/bin/install -c > checking whether build

Re: [GENERAL] DBlink, postgres to DB2

2014-10-30 Thread Postgres India
Hi , While i try to install psqlDDBC, i get this error , i have SUSE Linux Enterprise Server 11 , trying to find a solution still have no idea. ./configure checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for a thread-safe mkd

[GENERAL] Re[2]: [GENERAL] DBlink, postgres to DB2

2014-10-23 Thread Миша Тюрин
http://multicorn.org/ another cool stuff to generalize interconnections Wed, 22 Oct 2014 22:34:06 -0700 от Postgres India : >Thanks a lot Remi, Merlin and Pavel...I will give it a try. > >On Wed, Oct 22, 2014 at 6:36 AM, Merlin Moncure < mmonc...@gmail.com > wrote: >>On Wed, Oct 22, 201

Re: [GENERAL] DBlink, postgres to DB2

2014-10-22 Thread Postgres India
Thanks a lot Remi, Merlin and Pavel...I will give it a try. On Wed, Oct 22, 2014 at 6:36 AM, Merlin Moncure wrote: > On Wed, Oct 22, 2014 at 5:56 AM, Pavel Stehule > wrote: > > Hi > > > > try to use a Perl implementation https://github.com/davidfetter/DBI-Link > > > > There is a DBD dri

Re: [GENERAL] DBlink, postgres to DB2

2014-10-22 Thread Merlin Moncure
On Wed, Oct 22, 2014 at 5:56 AM, Pavel Stehule wrote: > Hi > > try to use a Perl implementation https://github.com/davidfetter/DBI-Link > > There is a DBD driver for DB2 http://search.cpan.org/dist/DBD-DB2/DB2.pod > > Or you can use a mentioned fdw wrapper - there is ODBC wrapper > https://wiki.po

Re: [GENERAL] DBlink, postgres to DB2

2014-10-22 Thread Pavel Stehule
Hi try to use a Perl implementation https://github.com/davidfetter/DBI-Link There is a DBD driver for DB2 http://search.cpan.org/dist/DBD-DB2/DB2.pod Or you can use a mentioned fdw wrapper - there is ODBC wrapper https://wiki.postgresql.org/wiki/Foreign_data_wrappers#odbc_fdw and you can access

Re: [GENERAL] DBlink, postgres to DB2

2014-10-22 Thread Rémi Cura
You may want to use foreign data wrapper (fdw) https://wiki.postgresql.org/wiki/Foreign_data_wrappers Cheers, Rémi-C 2014-10-22 12:50 GMT+02:00 Rémi Cura : > Hey > http://www.postgresql.org/docs/9.3/static/contrib-dblink-connect.html > Seems dblink is for postgres to postgres connections. > Che

Re: [GENERAL] DBlink, postgres to DB2

2014-10-22 Thread Rémi Cura
Hey http://www.postgresql.org/docs/9.3/static/contrib-dblink-connect.html Seems dblink is for postgres to postgres connections. Cheers, Rémi-C 2014-10-22 12:45 GMT+02:00 Postgres India : > Hi, > I am trying to connect DB2 from postgres using dblink, is there any > configuration required at DB2 an

[GENERAL] DBlink, postgres to DB2

2014-10-22 Thread Postgres India
Hi, I am trying to connect DB2 from postgres using dblink, is there any configuration required at DB2 and postgres server. If any command string please provide it. Thanks Manmohan. K