Archives of the TeradataForum
Message Posted: Tue, 22 Jun 2004 @ 11:56:33 GMT
| Subj: || || Re: Is it possible to manipulate activity count? |
| From: || || Victor Sokovin |
| ||We have a BTEQ script that takes certain action based on the ACTIVITYCOUNT. We want the activitycount to be zero before we run the script
but it is necessary to run a database statement before calling the BTEQ and this causes the ACTIVITYCOUNT to be set to 1. Is it possible to set it
to zero? .SET ACTIVITYCOUNT = 0 is not an acceptable command. We are using V2R4 in MVS environment.|| |
Would it be an option to include a simple dummy SELECT COUNT(*) statement from some empty table as the first statement in the script?