Kbase 14063: How to move Database (SCHEMA) Triggers ( PROPATH -trig )
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to move Database (SCHEMA) Triggers ( PROPATH -trig )
How to specify where Schema Triggers live
-----------------------------------------
To avoid hardcoding path names into the
Data Dictionary, You may specify the
directory or library where the schema triggers reside
by the -trig (on the command line) OR by
including it in the PROPATH.
Propath
-------
You can use PROPATH to specify the trigger
directory in a number of ways. For instance,
you can put a full path name into the PROPATH
and then simply refer to the trigger procedure by
name only in the Data Dictionary. Or you can specify
part of the path and use the rest of it in the
Data dictionary when specifying the trigger
procedure by name. In other words,
The directory specified in the Data Dictionary
can either be a full pathname or one relative to
a directory in the PROPATH. For example:
If crcust.p is specified in the data dictionary as
the trigger procedure, then the PROPATH must include a
reference to /dlc/sports.
If sports/crcust.p is specified in the data dictionary as the
trigger procedure then PROPATH must include a reference
to /dlc.
Startup Command (-trig)
-----------------------
This option is handy if you do not want to change
the PROPATH. You can simply specify the directory
(or library which must have the .pl extension) where the
triggers reside. This needs to be a full path name.
For example:
_prowin sports -trig /dlc/sports
Progress Software Technical Support Note # 14063