MLOAD Errors

Analytics

MLOAD Errors

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.
2 REPLIES

Re: MLOAD Errors

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.

N/A

Re: MLOAD Errors

If its a Unix File, try opening it in vi editor and check if their are any control characters in your file. This will cause Mload to abort with erorr code UTY4017