| problem with X'15 character while loading-urgent [message #69311] |
Fri, 07 December 2001 05:25  |
Prabha R
Messages: 2
Registered: December 2001
|
Junior Member |
|
|
Hi,
I'm getting a flat file from mainframes into unix server and loading into oracle using SQL Loader. In this flat file there are X'15 characters (which is ^M in unix) at some positions. The sql loader understands this as an end of record which is actually not and hence the data is not loaded properly in the tables. Could any of you suggest me on how to parse this X'15 character while loading. Your immediate help will be greatly appreciated.
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
