Can somebody write a simple FastExport script with IF ELSE condition. THe example given in info.teradata.com. I am not able to understand it.
THanks in Advance
I tried a simple running a simple script using BTEQ using Looping Condtion.
.IF 'TRUE'='TRUE' THEN;
.RUN FILE FastExport.txt;
bteq < script
I got a error relating to the FastExport LogFile. I tried this script refering to Page No.115(IF ELSE AND ENDIF). I don see a detailed information on how the Looping is done. Being a Learner, i understand this is how the script is runs for looping. ANd ALso in MLOAD a similar script to above is return to restart the LogTable.
If the "FastExport.txt" file contains FastExport commands, then this cannot be run through BTEQ.
A file that is used in the RUN FILE command in a BTEQ script, must contain only BTEQ commands.
If you want to run a FastExport job, then you need to invoke the FastExport utility from the command line.
IF ELSE is conditional statement. You read the line thus:
Your right. It is a conditional statement, i was wrong to call it looping. What i dont understand in the example or i don see a section which explains the way, conditional statement can be applied in FAST EXPORT. I request u to post a small example scripts which explains how the COndtional statement is applied.
After lot of R&D i understood how the IF ELSE statement can be applied.
.EXPORT OUTFILE exported;
SEL * FROM TABLENAME;
.IF 1=1 THEN;
.DISPLAY 'SUCCESS' TO FILE pathname;
Hope it helps learners like me to understand the how to apply IF ELSE statement.