moving text data type from one table to another.
Posted: Fri Feb 03, 2006 8:14 am
I'm trying to convert one table to another table, both containing a column of text data type, which Datastage interprets as longvarchar(2147483647) in the metadata. The data can be rather large, and could contain any variety of characters entered in the data. This should be a straight mapping.
Datastage is having problems reading from the source table for certain rows. Actually, it just kills the job with a less than informative message: Abnormal termination of stage exConvertMessage..stgxMessage detected. That's it.
I'm able to view these problematic rows without any problems in MSSQL Query Analyzer. However, attempting to view them from the ODBC stage in Datastage lock the job up.
I'm assuming that there's a character in the data that Datastage is having problems with. I don't readily see it.
Does anyone have any suggestions on dealing with these large data types?
Datastage is having problems reading from the source table for certain rows. Actually, it just kills the job with a less than informative message: Abnormal termination of stage exConvertMessage..stgxMessage detected. That's it.
I'm able to view these problematic rows without any problems in MSSQL Query Analyzer. However, attempting to view them from the ODBC stage in Datastage lock the job up.
I'm assuming that there's a character in the data that Datastage is having problems with. I don't readily see it.
Does anyone have any suggestions on dealing with these large data types?