Archives of the TeradataForum
Message Posted: Thu, 13 Jul 2006 @ 17:12:52 GMT
We do this renaming of UV tables in a MLOAD. The tables are renamed dynamically as follows
RENAME TABLE DB.UV_TB TO DB.UV_TB_&sysday&sysuvcnt
The JOB runs on a daily basis. This leads to frequent abends due to the below stated reason.
For Ex: Suppose this job is run on a MON and it generates a UV CNT of 10 then the UV table is rename to DB.UV_TB_MON10
This same JOB when run on the next MON may generate the same UV CNT 10. Thus giving rise to a abend "The table already exists"
I tried using sysdate and systime but it come with special char "/" or ":" which cannot be used for renaming a table.
Is there a way to rename the UV table using the date or time by formatting it so that it comes without the special chars??
Is there any other way of renaming the UV table uniquely so that the frequency of abends reduces??
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|