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
DataStage 7.5 and IQ12.6
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 214
- Joined: Mon Feb 23, 2004 2:10 am
- Location: Dublin, Ireland
- Contact:
Re: DataStage 7.5 and IQ12.6
Hi Luk,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
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?
-
- Participant
- Posts: 214
- Joined: Mon Feb 23, 2004 2:10 am
- Location: Dublin, Ireland
- Contact:
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.
funny we couldn't
we ended using windows ds server for imports.
please post when you resolve this.
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
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!
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!
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
"what the thinker thinks, the prover proves" - Robert Anton Wilson
I can't import table definitions using OC . It is only posible using ODBC!!
LUK
Both in IQ12.5 and 12.6 I can import table definitions using ODBC (both in Windows and Unix)!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.
LUK
Royroy 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.
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?
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
"what the thinker thinks, the prover proves" - Robert Anton Wilson