rs_script_parameters
The following table lists the columns for the rs_script_parameters view. The equivalent jcs_script_parameters view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.
| Column | Datatype | Description |
| OWNER | VARCHAR2 | The owner of the script |
| SCRIPT_NAME | VARCHAR2 | The script name |
| SCRIPT_ID | NUMBER | The unique script id |
| INTERNAL_PARAMETER_ID | NUMBER | The internal parameter id (needed to modify or delete the parameter) |
| PARAMETER_NAME | VARCHAR2 | The unique parameter name |
| ARRAY_PAR | VARCHAR2 | Is this an array parameter |
| ARRAY_SIZE | NUMBER | Array size for fixed-array parameters |
| DATA_TYPE | VARCHAR2 | The data type of the parameter (date, number, varchar2 or char) |
| DATA_LENGTH | NUMBER | The maximum parameter length |
| DATA_PRECISION | NUMBER | The precision, or total number of digits |
| DATA_SCALE | NUMBER | The number of digits to the right of the decimal point |
| PAR_IN | VARCHAR2 | Is the parameter an input parameter (Y or N)? |
| PAR_OUT | VARCHAR2 | Is the parameter an output parameter (Y or N)? |
| NULLABLE | VARCHAR2 | Is the parameter optional (Y or N)? |
| RUNTIME | VARCHAR2 | Is the parameter determined at runtime (Y or N)? |
| DISPLAY | VARCHAR2 | Is the parameter displayed (Y or N)? |
| EDITABLE | VARCHAR2 | May the default parameter value be overwritten? |
| EDITABLE_IF_NULL | VARCHAR2 | May a parameter value be specified if there is no default? |
| GENERATED | VARCHAR2 | The name of the system parameter when the value is generated by Redwood at runtime |
| PARAMETER_ID | NUMBER | The unique parameter id |
| DISPLAY_SEQUENCE | NUMBER | The sequence in which the parameters should be shown in the submit screens |
| INPUT_FORMAT | VARCHAR2 | The format string used to check the input value |
| OUTPUT_FORMAT | VARCHAR2 | The format string used to pass to child jobs or to the commandfile |
| DEFAULT_LENGTH | NUMBER | The length of the definition for the default parameter value |
| DATA_DEFAULT | VARCHAR2 | The definition of the default parameter value |
| DEFAULT_TYPE | VARCHAR2 | The type of the default parameter value definition |
| DESCRIPTION | VARCHAR2 | The parameter description |
| CMDFILE | VARCHAR2 | Is the parameter to be put into the CMDFILE |
| ALLOW_LAST_VALUE | VARCHAR2 | Is it allowed the use the last value from previous jobs |
| ISKEY | VARCHAR2 | Is this parameter part of the delete key |
| CONSTANT | VARCHAR2 | Is this parameter a constant parameter |
| GROUPNAME | VARCHAR2 | The GUI name of the parameter group |
| VISUAL_ATTRIBUTES | VARCHAR2 | Attributes that can be used by the GUI to store representational data |
| COMMENT_TEXT | VARCHAR2 | Comment describing the parameter |
note
DATA_TYPE: Datatypes DATE, TIME and DATETIME in v8 are all mapped to DATE. Datatype FILE is unknown in v6/7.
note
INPUT_FORMAT: Input formats are tried to be mapped to v6/7 formats, but may be still (partly) in v8 format.
note
VISUAL_ATTRIBUTES: Version 9 does not have visual attributes anymore, therefore this column is always empty
plsqlTopic
onsiteTopic