 |
 |
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?
Victor
| |
