Archives of the TeradataForum
Message Posted: Tue, 11 Mar 2003 @ 17:18:45 GMT
Thanks Anomy for your suggestion. I created a SQL Script file called "test.BTEQ" and put the .logon command at the beginning of it. Then I ran BTEQ as follows:
BTEQ < test.BTEQ
It ran correctly. The only problem is I don't know how to tell the LOG file to BTEQ.
Also, after each SQL statement in the script, I tried to access the ACTIVITYCOUNT and ERRORCODE and put it in the value clause of my process_log table insert entry as follows:
.if ERRORCODE <> 0 then .goto STOP_RUN
Somehow the ERRORCODE and the ACTIVITYCOUNT are not visible inside the value clause and the process errors out. Any idea how to fix that?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|