|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/28/2006 9:26:00 AM
Posts: 1,
Visits: 1
|
|
Is there a way to remove rows that have insufficient data in a record within an MLOAD so the MLOAD will continue to load the rows that are of the proper length?
**** 09:25:16 UTY4017 Not enough data in vartext record number 13145033.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 6/9/2008 2:55:55 PM
Posts: 185,
Visits: 2
|
|
Have you tried defining the input layout as a single VARCHAR column? Then, you should be able to only insert the rows where the length of the column was what you are looking for (using the APPLY WHERE clause).
If your columns are fixed length, you can then use the SUBSTR function to break the record down into the individual fields/columns. Or, if you have variable length columns, you could either p**** through the data or use a UDF to separate the columns.
|
|
|
|