DSXchange

Dear all, We are using DataStage 7.5 Server Edition. We can import ODBC table definition into DataStage. However, when we try to click the View Data button from the ODBC stage, we get the following error message: DSBrowser..ODBC_0.DSLink2: DSD.BCIOpenR call to OCONV failed. Please help. Thanks, Gordon

Hi Eric, I used UTF8 NLS in the ODBC Stage which represents the table in SQL Server: Stage->General->NLS->Choose UTF8 below "Map name to use with stages". After that, I click Outputs->View Data, I will get the NLS input mapping error and the wrong characters. Thanks. I expect you need to s...

Dear all, There is a column of NVARCHAR type in a table. The column stores some unicode characters such as "ﶳ" (a square). I want to export the table to a sequential file. But DS converts these characters to be question marks(?). I try UTF8 NLS setting but with no help. Please help, thanks...