Archives of the TeradataForum

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

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

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>>