Page 1 of 1
UPDATE row using OpenClient plug-in or ODBC
Posted: Thu Jan 20, 2005 6:40 am
by Luk
Hi!
How can I update few rows in no character format(ex. integer or numeric) in Sybase IQ 12.5 database using DataStage??
When I'm trying to do this , there is an error both in OC and ODBC. theese drivers can't convert character to decimal or integer type and DataStage always treats all formats (numeric also) as a charakter when using it as parameter
Data Stage parameter ?=' ... ' is always character!!!
Is the only way to do this is OpenClient plug-in or ODBC??
LUK
Posted: Thu Jan 20, 2005 7:34 am
by chulett
Not *quite* sure what the issue is here...
By 'parameter' do you mean bind variable? And I'm pretty sure that an expression where you compare something (like a parameter) to something in quotes
forces a string comparision and an implicit cast.
I haven't had issues like this using the Sybase OC that I recall, but I mostly stick with OCI. Can you provide a specific example of what you are doing and the error(s) that you are getting?
Re: UPDATE row using OpenClient plug-in or ODBC
Posted: Thu Jan 20, 2005 7:48 am
by peternolan9
Luk wrote:Hi!
How can I update few rows in no character format(ex. integer or numeric) in Sybase IQ 12.5 database using DataStage??
When I'm trying to do this , there is an error both in OC and ODBC. theese drivers can't convert character to decimal or integer type and DataStage always treats all formats (numeric also) as a charakter when using it as parameter
Data Stage parameter ?=' ... ' is always character!!!
Is the only way to do this is OpenClient plug-in or ODBC??
LUK
Hi Luk,
for IQ you must use the Sybase ODBC client, OC is not supported to IQ.
Your problem is a 'bug' introduced in 12.5.0. It used to work in 12..4.3. The patch is now available. You need to get ESD 11.4 for IQ 12.5.
The ESD 11 is on the sybase web site but I had to get .4 directly from Sybase...once you have ESD11.4 the implicit data conversion works again...
Glad to be of service....
...this is not something you would guess....
Posted: Thu Jan 20, 2005 7:56 am
by chulett
Oh, duh. Sybase IQ - sorry I didn't notice that bit.
Posted: Thu Jan 20, 2005 9:18 am
by Luk
Hi Peter!!
Thanks a lot!! I have sybase IQ :
Adaptive Server IQ/12.5.0/040702/P/ESD 11/Intel/Linux X86 2.4.9-e.25smp/32bit/20
I hope that 11.4 solve the problem. I will write to sybase
thanks again.
LUK