Archives of the TeradataForum
Message Posted: Fri, 09 Feb 2001 @ 13:29:55 GMT
Subj: | | Predefined System Variables with V2R4.01 |
|
From: | | Sharon Curley |
We just upgraded to V2.R4.01 and wanted to take advantage of the predefined system variables that are available to us now.
Our goal would be to store the predefined variables &SYSINSCNT , &SYSDELCNT, etc. as an insert to a Job Statistics type table and log the
number of inserts, deletes, etc. for our Multiload jobs.
We are have some trouble with the correct syntax for the multiload job (MVS) . If anyone has examples that you could share with us or
practical experience with these, it would be greatly appreciated.
Sharon Curley
Project Manager - MIS Marketing Business Systems
Lowe's Companies, Inc.
|