Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 05 Mar 2002 @ 18:23:35 GMT

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

Subj:   Re: DBC.ACCTG Table Maintenance
From:   John Hall

It sounds like you're using Account String Expansion (ASE). If so, then the options of the ASE feature expand into column ACCOUNTNAME. Depending on how you have it set, you probably have a date/time embedded in that column.

If it were my problem, I would pick a relatively quiet time on the system, create a table with the same definition as DBC.ACCTG, then I would do an INS/SEL into this new table (be sure that it's empty) from DBC.ACCTG and when that's done, I would do a DELETE ALL from DBC.ACCTG. Once done with that, you can deal with your new ACCTG table without an impact on the rest of the system.

You might consider setting-up a nightly job that does an INS/SEL from DBC.ACCTG into a history table and then delete the contents of DBC.ACCTG. From that point, you can then select some method for summarizing your ACCTG history table (if you want).

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