if statment in bteq?

Database
Enthusiast

if statment in bteq?

1.Is there any way i can use a if statment in bteq.If so can anyone provide me with the syntax
2.Also is it possible to pass parameters to bteq ?
3. Is it possible to use variables, assig nvalues to variables?
1 REPLY
Teradata Employee

Re: if statment in bteq?

Q: Is there any way i can use a if statment in bteq.If so can anyone provide me with the syntax
A: Limited to test condition: ERRORCODE, ACTIVITYCOUNT and ERRORLEVEL
Tests conditions you can use
= (equal to)
> (greater than)
< (less than)
>= (greater than or equal to)
<= (less than or equal to)
<> (not equal)
!= (not equal)
~= (not equal)
^= (not equal)

eg:

.IF ERRORCODE > 0 THEN .GOTO FAILED

.QUIT 0;

.LABEL FAILED
ABORT 'FAILURE';

Q: Also is it possible to pass parameters to bteq ?
A: No - but you can use macros and stored procedures here.

Q: Is it possible to use variables, assig nvalues to variables?
A: No - but stored procedures will allow variables