Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Dynamic Table Script Id |
The automatically generated primary key of the dyn_table_script table. |
LONG |
Yes |
Dynamic Table Script Name |
The name of the Dynamic Table Script. |
VARCHAR(255) |
Yes |
Script Type Id |
A Foreign Key to the Dynamic Table Script Type table. |
LONG |
Yes |
Target DBMS Id |
The unique identifier for an instance of Target DBMS. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values.
|
LONG |
Yes |
SQL Script |
The value of a Dynamic Table Script, stored as a long text object. |
TEXT |
Yes |
Is Active |
Indicates if the script is the active version, or if it is a superceded version. When deployment loads the script, the SQL text of the script is compared with any existing active row. If it is equal, the script is not loaded. If unequal, the existing script is marked inactive, and a new active script is loaded.
|
BOOLEAN |
Yes |
Script Sort Order |
A sort number used to order a list of Dynamic Table Script. |
INTEGER |
Yes |
Definition Subtype Id |
A Foreign Key to the Definition Subtype table. |
INTEGER |
Yes |
Run As Proxy |
Used for Oracle, indicating if a proxy connection to impersonate the schema account is needed. |
BOOLEAN |
No |