Archives of the TeradataForum
Message Posted: Tue, 05 Mar 2002 @ 18:23:35 GMT
| 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).