How do you view the character symbolizing the "end-of-row" in a data file?
I have a record in a file which gives an error. But if I isolate it and process it alone, it gives no errors. If the record one before and after of the error record are processed with the error record (as the second record in the file), the process failes. I assume that the reason is for not having the "end-of-row" character in that error record.
Any ideas how to figure this out ?.
Following is the error I get.
SQLSTATE=22005, DBMS.CODE=-99999
[DataStage][SQL Client][ODBC][IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005
How to view the character symbolize end-of-row
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Tue Oct 07, 2003 8:20 am
- Location: USA
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom