Archives of the TeradataForum

Message Posted: Thu, 04 May 2006 @ 15:45:15 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Anomy,

Naming Macro in Tpump Job
-------------------------

The macros are named according to the following convention:

     Jobname_DDD_SSS

where

* Jobname is the job name, which, if not explicitly specified, defaults to:

          MYYYYMMDD_HHMMSS_LLLLL.

* LLLLL is the low order 5 digits of the logon sequence number returned by the dbs from the .LOGON command.

* DDD is the number of the .DML sequence (ordinal) number. This value is not reset to one for successive loads (.BEGIN LOAD) in a single job, but continues to be incremented.

* SSS is the SQL statements sequence (ordinal) number within the .DML group.

I guess you are running multiple tpumps (with no Jobname) at a time resulting in same macro creation MYYYYMMDD_HHMMSS_LLLLL by multiple jobs.

Hope this clarifies.

-Naresh

	<Prev	Next>		<<First	<Prev	Next>	Last>>