Copy Window allows you to generate the scripts necessary to copy a window from one schema to another (or from one menu to a new menu). The system creates an Oracle SQL script that creates a specific window according to the defined parameters.
The Copy Window contains two parts. The upper part shows the parameters needed for generating the script to copy the window. The lower part of the window shows the resulting script that you can copy and run in a different instance to copy the window to that instance. The upper part of the window contains the following fields:
- Output Type: This field contains a drop-down list that allows you to select whether the script will contain DML, DDL, or both DML and DDL statements. DML is the default value. The differences between DML and DDL options are described below:
DML: This option places all INSERT statements into tables (such as SETUP_WINDOWS, WEB_WINDOWS_OBJECTS, WEB_WINDOWS_COLUMN, and so on) in the generated script. Selecting this option will not generate any CREATE statements for tables, views, function, or procedures.
| Note: This option is equivalent to scripts generated by the Copy Window in version 6.9 and below. |
- DDL: This option forces the system to discover all procedures defined in WEB_WINDOWS_OBJECTS.DATA_SOURCE and all tables/views defined in WEB_WINDOWS_OBJECTS.UPDATE_TABLE. It will generate a CREATE statement for each object as well as any tables, views, functions, or procedures that it may rely on.
- Save Config Script: When this check box is selected, the system prompts you for a file name for the generated script and then stores the script in the SYSTEM_CONFIG_SCRIPT table.
- Schema Qualifier: If desired, you may preface each object name in the generated script with the string entered in this field.
- Source DB: This field displays the name of the source database and is automatically completed by the system when you open the Copy Window window.
| Note: This field may define an optional port number and SID for the Oracle server. This is done by separating the host name, port number, and SID with a colon (such as mydbhost:1521:mysid). If you do not use this syntax, then the system will automatically assume it should use the default port for Oracle (which is 1521) and use the host name as the SID. For example, entering the string agiledb will force the system to generate agiledb:1521:agiledb for the JDBC connection URL. |
- Source Password: This field contains the password to access the source database and is automatically completed by the system when you open the Copy Window window. (The password displays as a series of asterisks.)
- Source Schema: This field contains the name of the source schema and is automatically completed by the system when you open the Copy Window window.
- Source Window ID: This field contains the window ID of the window to be copied.
- Target Menu ID: This field contains the ID of the menu in which the copied window will appear after the script is run.
- Target Window ID: This field contains the ID that the copied window will have in the target database.
The Get Script command button causes the system to generate a script using the entered parameters and display it in the lower part of the window.