Posted by [IP Address: 24.190.56.109] 'rs' on May 14, 2001 at 19:35:38 EST:
In Reply to: record editor in css/hrizon posted by [IP Address: 24.190.56.109] 'Shaun Rudolph' on May 10, 2001 at 20:31:26 EST:
All the record editor defaults will be be defined in PSDDLPARMS
table, which you can find it under utilities menu.
When a new record is build it uses these DDL parms.
There are two ways you can change them.
1. Override the defaults itself, which impacts all the record build process.
2. Override for specific record in record editor ddl.You can find these overrides in PSRECDDLPARM table.
: This concerns a technical issue of how the Record DDL is used in the Css/Hrizon application for Charter Clients. Incidently Css/Hrizon uses the same general architecture as PeopleSoft
: Platform: Oracle 8.0.5 on sun 5.6 Unix Server
: Application: Windows NT
: Our DBA has informed us that our default Percent Increase is 50 % and is not good for our system when we want to bring over new tables from our test environment to production. This causes fragmentation and performance problems.
: We would like to know how we can override this thur the record editor (see ddl screen print below). We tried to override the DDL Model defaults in the record editor but it caused a problem in our test environment. We don't want to have to save a sql from the record editor and put it in a sql script because we don't want to have the database out of sync with respect to the record editor. We want to perform the override of the % increase within the record editor. Please advise us as to what we should do. I have checked the knowledge base and don't see anything that pertains to us.
: Is it a safe work around to save the record to a sql script and carefully add the percent increase and run it from Oracle's sqlplus? It is a bad alternative as we would need to maintain the sql script if we can't do it from the record editor. seems like dual maintenance.