Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Jul 2006 @ 17:12:52 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Renaming UV tables
From:   Aravind Raghu

Hi all,

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

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020