DataStage 7.5.x with Sybase IQ 12.6 on Linux
Posted: Fri Oct 27, 2006 3:09 am
Hi,
As far as I know (after searching the forum) this has not being covered before.
We are able to connect to the IQ database using both ODBC and Open Client.
The Sybase Open Client is behaving rather strangely. To just list a couple of scenarios:
Have a Sybase OC Stage connecting to a table and doing a simple select,
select max(skey) from xTable.. Instead of getting one row, all the rows are returned. The sql shows the correct syntax. After changing to a Dynamic RDBMS Stage, same thing happens when Sybase is selected as a server type. But after changing to ODBC as a server type, one row is selected.
Another issue-view data returns a blank error in datastage[message box with exclamation and ok button, but no error message] when using sybase oc and returns data when using ODBC.
The problem is that these issues are not consistant. This happens with some of the jobs and not all of them.
Has anybody come across this before?
Any suggestions?
Thanks,
As far as I know (after searching the forum) this has not being covered before.
We are able to connect to the IQ database using both ODBC and Open Client.
The Sybase Open Client is behaving rather strangely. To just list a couple of scenarios:
Have a Sybase OC Stage connecting to a table and doing a simple select,
select max(skey) from xTable.. Instead of getting one row, all the rows are returned. The sql shows the correct syntax. After changing to a Dynamic RDBMS Stage, same thing happens when Sybase is selected as a server type. But after changing to ODBC as a server type, one row is selected.
Another issue-view data returns a blank error in datastage[message box with exclamation and ok button, but no error message] when using sybase oc and returns data when using ODBC.
The problem is that these issues are not consistant. This happens with some of the jobs and not all of them.
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
Has anybody come across this before?
Any suggestions?
Thanks,