All Forums Tools
ECernega 1 post Joined 11/14
06 Nov 2014
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
 

Ivyuan 63 posts Joined 01/10
06 Nov 2014

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.

You must sign in to leave a comment.