Archives of the TeradataForum

Message Posted: Fri, 06 Dec 2002 @ 16:05:23 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Following is the part of my multiload script.

.import infile &fname
        format text
        layout inslayout
        apply insdml;
.end mload;
.IF &SYSETCNT1 NE 0 THEN;
.DISPLAY &fname to file 'errorlog.txt';
.LOGOFF 24;
.ELSE;
.ENDIF;
.IF &SYSUVCNT1 NE 0 THEN;
.DISPLAY &fname to file 'error.txt';
.LOGOFF 25;
.ELSE;
.ENDIF;
.log off ;

The last command is wrong because I want to generate error situation in running the script again.

With this in mind following is the part of output of running the script

**** 09:28:26 UTY0823 Restart in progress, processing for this MultiLoad task has already been completed.

 -----------------------------------------------------------------------
 -
 -          Processing Control Statements
 -
 -----------------------------------------------------------------------
0056 .IF &SYSETCNT1 NE 0 THEN;
**** 09:28:26 UTY2402 Previous statement modified to:
0057 .IF 0 NE 0 THEN;
0058 .DISPLAY &fname to file 'errorlog.txt';
0059 .LOGOFF 24;
0060 .ELSE;
0061 .ENDIF;
0062 .IF &SYSUVCNT1 NE 0 THEN;
**** 09:28:26 UTY2402 Previous statement modified to:
0063 .IF 0 NE 0 THEN;
0064 .DISPLAY &fname to file 'error.txt';
0065 .LOGOFF 25;
0066 .ELSE;
0067 .ENDIF;
0068 .log off ;
**** 09:28:26 UTY0009 Unrecognizable command: "log".

 -----------------------------------------------------------------------
 -
 -          Logoff/Disconnect
 -
 -----------------------------------------------------------------------
**** 09:28:26 UTY6215 The restart log table has NOT been dropped.
**** 09:28:26 UTY6212 A successful disconnect was made from the RDBMS.
**** 09:28:26 UTY2410 Total processor time used - '0.0300432 Seconds'
     .       Start : 09:28:22 - FRI DEC 06, 2002
     .       End   : 09:28:26 - FRI DEC 06, 2002
     .       Highest return code encountered - '8'.

The problem is, it did not make any error.txt.

What I have done wrong

THANX

Mayur

	<Prev	Next>		<<First	<Prev	Next>	Last>>