Problem using the . (dot) commands with the fastload

Database
Enthusiast

Problem using the . (dot) commands with the fastload

i am need help in writing the fastload script

i am having problem using the commands: .SET, .IF.

I need to use these commands before the dropping the error tables at the start of Fastload script.

I am calling my Fastload script using the JCL on the mainframe platform.

The commands that I use are below:
.SET ERRORLEVEL 3807 SEVERITY 0;
.IF ERRORCODE <> 0 THEN .EXIT ERRORCODE

It gives me the error: Invalid Fastload statement

Please let me know how resolve this issue, as I am getting an error code 8 if i dont use these command with the message: error tables do not exist, when i drop the fastload error tables.
3 REPLIES
Teradata Employee

Re: Problem using the . (dot) commands with the fastload

Those are BTEQ commands. FastLoad provides no conditional execution. You could run a BTEQ step followed by a FastLoad step.
Enthusiast

Re: Problem using the . (dot) commands with the fastload

Thanks for the reply
Can I use the .SET, .IF.... commands in MLOAD?
I am new to teradata utilities.
Enthusiast

Re: Problem using the . (dot) commands with the fastload

Yes, you can use both .SET and .IF commands with MLOAD Utility.

Example-1:
------------
.SET Var1 TO 10;

The above statement will assign value 10 to the variable called Var1.

the same way .IF command,

Example-2:
------------
.IF &SYSUVCNT > 0 THEN;

The above statement will check whether UV Count is > 0, if so the MLOAD will return error.