Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 22 Nov 2002 @ 21:03:37 GMT


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


Subj:   Re: How to USE IF THEN ELSE in MultiLoad
 
From:   Madhu Reddy

Hi,

ELSE Statement not executing in following script..

****************************************
.logtable madhu1.ivp_log;
.logon demo1099/madhu1,madhu;
.IF &sysrc = 0 THEN;
.DISPLAY 'LOGON SUCCESSFUL &sysrc' TO FILE *;
.ELSE;
.DISPLAY 'logon failure!!!!!' TO FILE *;
.ENDIF;
****************************************

following is output

------------------------------------------------------
     .logtable madhu1.ivp_log;
0002 .logon demo1099/madhu1,;
**** 14:54:14 UTY1007 RDBMS error: 3003, Invalid password.
**** 14:54:14 UTY2410 Total processor time used '0.0701008 Seconds
     .       Start : 14:54:13 - FRI NOV 22, 2002
     .       End   : 14:54:14 - FRI NOV 22, 2002
     .       Highest return code encountered = '12'.
------------------------------------------------------

Here it should display logon failure message...
but it is not displaying logon failure....
what could be the reason?

it is exiting immediately after the logon command ....

if it exits immediatelf after logon command, there no use for IF THEN ELS..

THANX

-Madhu



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019