mload with NOSTOP option ends with Return Code 4

Tools

mload with NOSTOP option ends with Return Code 4

Hello,

In my mload script i have the following:

0037 .IMPORT INFILE xxxx

        FROM 4

        FORMAT  VARTEXT '^\' NOSTOP

        LAYOUT &load_table.

        APPLY Inserts;

The multiload skips the errors and inserts the records which respects the conditions

     ========================================================================

     =          MultiLoad Initial Phase                                     =

     ========================================================================

**** 01:00:27 UTY0829 Options in effect for this MultiLoad import task:

     .       Sessions:    9 session(s).

     .       Checkpoint:  15 minute(s).

     .       Tenacity:    4 hour limit to successfully connect load sessions.

     .       Errlimit:    No limit in effect.

     .       AmpCheck:    In effect for apply phase transitions.

**** 01:00:28 UTY0812 MLOAD session(s) requested: 9.

**** 01:00:28 UTY0815 MLOAD session(s) connected: 9.

     ========================================================================

     =          MultiLoad Acquisition Phase                                 =

     ========================================================================

**** 01:00:31 UTY4014 Access module error '61' received during 'pmReadDDparse'

     operation: 'Warning, too few columns !ERROR! Delimited Data Parsing error:

     Too few columns in row 1'

**** 01:00:31 UTY1808 Record 1 of Import 1 rejected due to preceding error.

**** 01:00:31 UTY4014 Access module error '61' received during 'pmReadDDparse'

     operation: 'Warning, too few columns !ERROR! Delimited Data Parsing error:

     Too few columns in row 2'

**** 01:00:31 UTY1808 Record 2 of Import 1 rejected due to preceding error.

**** 01:00:31 UTY4014 Access module error '61' received during 'pmReadDDparse'

     operation: 'Warning, too few columns !ERROR! Delimited Data Parsing error:

     Too few columns in row 3'

**** 01:00:31 UTY1808 Record 3 of Import 1 rejected due to preceding error.

**** 01:00:32 UTY0826 A checkpoint has been taken, recording that end of file

     has been reached for IMPORT 1 of this MultiLoad Import task.

**** 01:00:32 UTY1803 Import processing statistics

     .                                       IMPORT  1     Total thus far

     .                                       =========     ==============

     Candidate records considered:........       11632.......       11632

     Apply conditions satisfied:..........       11629.......       11629

     Candidate records not applied:.......           0.......           0

     Candidate records rejected:..........           3.......           3

But it ends with return code 4

     ========================================================================

     =          Logoff/Disconnect                                           =

     ========================================================================

**** 01:00:38 UTY6216 The restart log table has been dropped.

**** 01:00:38 UTY6212 A successful disconnect was made from the RDBMS.

**** 01:00:38 UTY2410 Total processor time used = '1.02 Seconds'

     .       Start : 01:00:26 - WED NOV 05, 2014

     .       End   : 01:00:38 - WED NOV 05, 2014

     .       Highest return code encountered = '4'

I have no other errors except the rejected records.

If i use tpump with NOSTOP option the return code is 0

My question: Is this the normal behavior of multiload and tpump if we use NOSTOP option?

I was expecting for both (mload and tpump) to have the same behavior and to finish with Return Code 0

I'm running on TD14.10

Thank you,

EC

Tags (3)
1 REPLY
Teradata Employee

Re: mload with NOSTOP option ends with Return Code 4

Hi,

The return code handling for this case is different between MultiLoad and TPump.

MultiLoad sets the return code to 4 due to the rejected rows, while TPump does not.

Thanks!

--Ivy.