Special Character to Sequential File
Posted: Mon Jan 20, 2003 6:17 am
Dear Experts,
We're having a big problem here everytime we want to write a sequential file with the data coming from a SQL Server 2000. The thing is,the operational application stores the data as rows in the SQL Server with BLOB datatype. And we have to extract the data first from the BLOB table and write it to the text. We're using a conversion : ICONV(ICONV('blob.data',"MXOC"),"MXOC") to convert the BLOB data to the text file.
The job run smoothly if the data doesn't have any Thai character. But we always failed to write the sequential file if the BLOB data has Thai character inside.
Our Datastage is NLS enabled, and PC874 is our default NLS. We have no problem reading a text file with Thai Character inside, or reading from a table with Thai Character as the values. But we always have problem writing THAI Character files to sequential files with data coming from the SQL Tables.
Btw, we are writing the target files to a Sun Solaris machine.
Can you help us? We really need help with this, since almost 90% of the data source are in BLOB and have Thai Character.
Thanks in advance...
Endy
We're having a big problem here everytime we want to write a sequential file with the data coming from a SQL Server 2000. The thing is,the operational application stores the data as rows in the SQL Server with BLOB datatype. And we have to extract the data first from the BLOB table and write it to the text. We're using a conversion : ICONV(ICONV('blob.data',"MXOC"),"MXOC") to convert the BLOB data to the text file.
The job run smoothly if the data doesn't have any Thai character. But we always failed to write the sequential file if the BLOB data has Thai character inside.
Our Datastage is NLS enabled, and PC874 is our default NLS. We have no problem reading a text file with Thai Character inside, or reading from a table with Thai Character as the values. But we always have problem writing THAI Character files to sequential files with data coming from the SQL Tables.
Btw, we are writing the target files to a Sun Solaris machine.
Can you help us? We really need help with this, since almost 90% of the data source are in BLOB and have Thai Character.
Thanks in advance...
Endy