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
UPDATE row using OpenClient plug-in or ODBC
Moderators: chulett, rschirm, roy
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?
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
peternolan9
- Participant
- Posts: 214
- Joined: Mon Feb 23, 2004 2:10 am
- Location: Dublin, Ireland
- Contact:
Re: UPDATE row using OpenClient plug-in or ODBC
Hi Luk,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
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....