DataStage 7.5 and IQ12.6

Luk · Post by **Luk** » Fri Jan 28, 2005 5:16 am

Hi!
Did someone try to connect to sybase IQ 12.6 using ODBC or Sybase Openclient ang get Table definition in Unix!!
I was using sybase IQ 12.5 and everything was OK but with IQ 12.6 I can't do this.

LUK

peternolan9 · Post by **peternolan9** » Fri Jan 28, 2005 6:10 am

Luk wrote:Hi!
Did someone try to connect to sybase IQ 12.6 using ODBC or Sybase Openclient ang get Table definition in Unix!!
I was using sybase IQ 12.5 and everything was OK but with IQ 12.6 I can't do this.

LUK

Hi Luk,
you might be out on the leading edge there a bit 12.6 is pretty new...I put an append up about esd 11.4 which was needed for 12.5....perhaps it is the same problem back again for 12.6?? What error message do you get?

Is it the implicit data conversion error message again?

Luk · Post by **Luk** » Mon Jan 31, 2005 2:19 am

Hi!
DS is trying to retrive information abouty tables through ODBC and it stops without any error massage.

But I have already fix it , I used libdbodbc9_n.so driver instead of libdbodbc9.so driver and ODBC is working fine !!

LUK

peternolan9 · Post by **peternolan9** » Mon Jan 31, 2005 3:52 am

Luk wrote:Hi!
DS is trying to retrive information abouty tables through ODBC and it stops without any error massage.

But I have already fix it , I used libdbodbc9_n.so driver instead of libdbodbc9.so driver and ODBC is working fine !!

LUK

And the _n driver is????

Luk · Post by **Luk** » Mon Jan 31, 2005 4:58 am

And the _n driver is????

I don't know exactly what you mean!! With Sybase IQ 12.6 there was 3 files libdbodbc9.so, libdbodbc9_r.so, libdbodbc9_n.so!!!

When I take _n file as a ODBC driver - connection in DS works OK.
In Sybase documentation there is information only about libdbodbc9.so driver!

LUK

roy · Post by **roy** » Mon Jan 31, 2005 5:54 am

Realy you did it in IQ 12.5???
funny we couldn't

we ended using windows ds server for imports.
please post when you resolve this.

denzilsyb · Post by **denzilsyb** » Mon Jan 31, 2005 6:01 am

Hi Luk

Can you import table definitions using the OC? As far as I am aware, you can only import table definitions using ODBC (which is what you re doing). I ask because if you can import using OC, its a major change from IQ12.5 - and a positive one at that!

Luk · Post by **Luk** » Mon Jan 31, 2005 7:51 am

I can't import table definitions using OC

. It is only posible using ODBC!!

Realy you did it in IQ 12.5???
funny we couldn't
we ended using windows ds server for imports.
please post when you resolve this.

Both in IQ12.5 and 12.6 I can import table definitions using ODBC (both in Windows and Unix)!

LUK

denzilsyb · Post by **denzilsyb** » Mon Jan 31, 2005 7:55 am

roy wrote:Realy you did it in IQ 12.5???
funny we couldn't
we ended using windows ds server for imports.
please post when you resolve this.

Roy

its all about setting up your .odbc.ini and dsenv with IQ. As Luk points out, OC cannot import table defs, only ODBC.

How did you do it using DS server?

DSXchange

DataStage 7.5 and IQ12.6

DataStage 7.5 and IQ12.6

Re: DataStage 7.5 and IQ12.6