Older RPROF tables, those installed before Composer 4, do not have date and time columns. CA Gen does not require the columns, but they are helpful in maintaining the table. To add date and time columns to RPROF, use the following SQL statements:
ALTER TABLE RPROF ADD RPROF_DATE DATE NOT NULL WITH DEFAULT; ALTER TABLE RPROF ADD RPROF_TIME TIME NOT NULL WITH DEFAULT;
If you add these columns, rows added before the ALTER statement contains the date and time that the ALTER statement executes. The new rows contain the correct date and time.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|