The online Unload function is used to unload data from an FDIC in Migrate format. The scope of this function is determined by one or more extracts. It is not possible to specify individual objects.
Using commands you can also write individual objects to the Coordinator FDIC in Migrate format.
This section covers the following topics:
Call the function by entering code U in the Coordinator Main Menu.
09:22:34 ***** P R E D I C T ***** 2013-05-31
- Unload Extracts -
Extract ID * No. Extract ID * No.
1 6
2 7
3 8
4 9
5 10
Unload options Build set for unloading No.
With code ..............* N Metadata ................ N (Y/N)
With profile ............ N (Y/N) Retrieval models ........ N (Y/N)
With internal ID ........ Y (Y/N) XRef data ............... N (Y/N)
Include Extracts ........ N (Y/N)
Target environment .....* 85
Create Report listing ... Y (Y/N)
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
- - Stop - - Flip Print - - - - -
|
| Parameters | |
|---|---|
| Extract ID | Up to ten extracts can be specified. You can enter an asterisk to select an extract from a list. The No. column displays the number of objects contained in the extract. |
| Unload options | These are described in detail below. |
| Build set for unloading | The following types of data can be unloaded
without using extracts. The column No. on the right indicates the
number of metadata object types, retrieval models and XRef data members which
will be unloaded.
|
There are two methods of unloading Predict objects:
Using extracts. Using the menu functions, you can only unload objects that are contained in an extract. Up to ten extracts can be specified for one unload operation. For more information see the section Extract in the Predefined Object Types in Predict documentation.
Using unload commands. In the command line you can also specify individual objects or ranges of objects. The scope of the function can be limited by parameters. See Overview of Command Keywords.
Applies to the following Predict-owned external objects connected to Predict file objects:
DDMs
Copy code members
Card formats such as ADAWAN, ADACMP.
If this parameter is set to Y, the connected external objects will be unloaded together with the file object only if the file has not been modified since generation.
If this parameter is set to M, the connected external objects will be unloaded even if the file object has been modified after generation.
Applies to objects of type user: If this parameter is set to Y, Predict and LIST XREF profiles are unloaded, too.
Determines whether objects are unloaded with or without Internal ID. See Internal ID.
If this parameter is set to Y, an object is unloaded with its internal ID. An object with the same internal ID is added in the target environment. The object remains coupled with the object in the source environment by means of this internal ID.
If this parameter is set to N, an object is unloaded without its internal ID. An object with a new internal ID is added in the target environment. The object is no longer coupled with the object in the source environment.
If this parameter is set to Y, the extract(s) used for the Unload function will also be unloaded.
Data can be unloaded to the following environments:
84
Predict 8.5 Data is unloaded in Migrate 8.4 format.
85
Predict 8.5 Data is unloaded in Migrate 8.5 format.
If this parameter is set to Y (default), a report listing of type UNL is created on the Main FDIC.
With Unload commands you can unload objects of different types selectively. The command used depends on the object type.
The following rules apply when an object type is required for a migrate command:
Specify the object type as two-character code or long name of a Predict object type (predefined or user-defined).
For example:
UNLOAD OBJECTTYPE PR
or
UNLOAD OBJECTTYPE PROGRAM
will unload objects of type program.
Enter command
UNLOAD OBJECTTYPE ALL <parameters>
Unloads Predict objects of all object types to a transfer medium.
| Keyword | Field | Position |
|---|---|---|
| FROM-DATE | From date | 1 |
| KEY | With keyword | 2 |
| OWNER | With owner ID | 3 |
| CODE | With code/profile | 4 |
| INTERNAL-ID | With internal ID | 5 |
| TARGET | Target environment | 6 |
| CREATE-RT | Create Report Listing | 7 |
Enter command
UNLOAD OBJECTTYPE <object type> <parameters>
| Keyword | Field | Position |
|---|---|---|
| ID | Object ID | 1 |
| TYPE | Object of type | 2 |
| FROM-DATE | From date | 3 |
| KEY | With keyword | 4 |
| OWNER | With owner ID | 5 |
| ALL | All option | 6 |
| CODE | With code | 7 |
| INTERNAL-ID | With internal ID | 8 |
| TARGET | Target environment | 9 |
| CREATE-RT | Create Report Listing | 10 |
Enter command
UNLOAD OBJECTTYPE <object type> <parameters>
| Keyword | Field | Position |
|---|---|---|
| ID | Object ID | 1 |
| FROM-DATE | From date | 2 |
| KEY | With keyword | 3 |
| OWNER | With owner ID | 4 |
| INTERNAL-ID | With internal ID | 5 |
| TARGET | Target environment | 6 |
| CREATE-RT | Create Report Listing | 7 |
Enter command
UNLOAD OBJECTTYPE IE <object type> <parameters>
| Keyword | Field | Position |
|---|---|---|
| ID | Object ID | 1 |
| FROM-DATE | From date | 2 |
| KEY | With keyword | 3 |
| OWNER | With owner ID | 4 |
| ALL | All option | 5 |
| INTERNAL-ID | With internal ID | 6 |
| TARGET | Target environment | 7 |
| CREATE-RT | Create Report Listing | 8 |
Enter command
UNLOAD OBJECTTYPE <object type> <parameters>
| Keyword | Field | Position |
|---|---|---|
| ID | Object ID | 1 |
| FROM-DATE | From date | 2 |
| KEY | With keyword | 3 |
| OWNER | With owner ID | 4 |
| ALL | All option | 5 |
| CODE | With code | 6 |
| INTERNAL-ID | With internal ID | 7 |
| TARGET | Target environment | 8 |
| CREATE-RT | Create Report Listing | 9 |
Enter command
UNLOAD OBJECTTYPE <object type> <parameters>
| Keyword | Field | Position |
|---|---|---|
| ID | Object ID | 1 |
| TYPE | Object of type | 2 |
| FROM-DATE | From date | 3 |
| KEY | With keyword | 4 |
| OWNER | With owner ID | 5 |
| ALL | All option | 6 |
| INTERNAL-ID | With internal ID | 7 |
| TARGET | Target environment | 8 |
| CREATE-RT | Create Report Listing | 9 |
Enter command
UNLOAD OBJECTTYPE RL <parameters>
| Keyword | Field | Position |
|---|---|---|
| ID | File relation ID | 1 |
| TYPE | File relation of type | 2 |
| FROM-DATE | From date | 3 |
| KEY | With keyword | 4 |
| OWNER | With owner ID | 5 |
| INTERNAL-ID | With internal ID | 6 |
| TARGET | Target environment | 7 |
| CREATE-RT | Create Report Listing | 8 |
Enter command
UNLOAD OBJECTTYPE US <parameters>
| Keyword | Field | Position |
|---|---|---|
| ID | User ID | 1 |
| FROM-DATE | From date | 2 |
| KEY | With keyword | 3 |
| OWNER | With owner ID | 4 |
| PROFILE | With profile | 5 |
| INTERNAL-ID | With internal ID | 6 |
| TARGET | Target environment | 7 |
| CREATE-RT | Create Report Listing | 8 |
Enter command
UNLOAD OBJECTTYPE VE <parameters>
| Keyword | Field | Position |
|---|---|---|
| ID | Verification ID | 1 |
| STATUS | Verification of status | 2 |
| FROM-DATE | From date | 3 |
| KEY | With keyword | 4 |
| OWNER | With owner ID | 5 |
| CODE | With code | 6 |
| INTERNAL-ID | With internal ID | 7 |
| TARGET | Target environment | 8 |
| CREATE-RT | Create Report Listing | 9 |
Enter function code U and data type M in the Coordinator main menu, or enter Y for parameter Metadata in the Unload Extracts screen. The following screen appears.
13:13:29 ***** P R E D I C T ***** 2013-05-31
- Build set for METADATA -
Object type ..................*
Unload options
From date ................... 0000-00-00 00:00 (YYYY-MM-DD HH:II)
|
Leave this field blank to unload metadata for all object types, or enter an object type code to unload metadata for a specific object type.
To specify metadata for several object types, the additional screen must be called up repeatedly.
If you specify a date in this field, only metadata created on or after the date specified will be unloaded.
UNLOAD METADATA <object type> <parameters>
| Object Type | Code | Keyword | Field | Position |
|---|---|---|---|---|
| any object type | any code | FROM-DATE | From date | 1 |
| ALL | blank | INTERNAL-ID | With internal ID | 2 |
| TARGET | Target environment | 3 | ||
| CREATE-RT | Create Report Listing | 4 |
Enter function code U and data type R in the Coordinator main menu, or enter Y for parameter Retrieval models in the Unload Extracts screen. The following screen appears:
13:06:56 ***** P R E D I C T ***** 2013-05-31
- Build set for RETRIEVAL MODEL -
Object type ..................*
Retrieval model ...............
Unload options
From date ................... 0000-00-00 00:00 (YYYY-MM-DD HH:II)
|
- Object type
Leave this field blank to unload retrieval models for all object types, or enter an object type code to unload retrieval models for a specific object type.
To specify retrieval models for several object types, the additional screen must be called up repeatedly.
- Retrieval model
If an object type is specified, a retrieval model ID can be entered to limit the scope of the function. The ID can be either unique or with asterisk notation.
- From date
If you specify a date in this field, only retrieval created on or after the date specified will be unloaded.
To unload retrieval models of a specific type from the transfer medium, enter command:
UNLOAD RETRIEVALMODEL <object type> <parameters>
where <object
type> is any Predict object type (predefined or
user-defined). See Specifying
the Object Type
| Keyword | Field | Position |
|---|---|---|
| ID | Retrieval model | 1 |
| FROM-DATE | From date | 2 |
| INTERNAL-ID | With internal ID | 3 |
| TARGET | Target environment | 4 |
| CREATE-RT | Create Report Listing | 5 |
To unload retrieval models of all object types from the transfer medium, enter command:
UNLOAD RETRIEVALMODEL ALL <parameters>
| Keyword | Field | Position |
|---|---|---|
| FROM-DATE | From date | 1 |
| INTERNAL-ID | With internal ID | 2 |
| TARGET | Target environment | 3 |
| CREATE-RT | Create Report Listing | 4 |
Natural XRef data is normally loaded and unloaded with Natural utilities. If, however, you wish to unload XRef data from one FDIC file to another, the Unload function can be used.
Enter function code U, data type O and object code XR in the Coordinator main menu, or enter Y for parameter XRef data in the Unload Extracts screen. The following screen appears.
13:27:32 ***** P R E D I C T ***** 2013-05-31
- Build set for XREF -
Member ........................
Library .......................
User system Fnr ............... (0-32767)
User system DBnr .............. (0-65535)
Unload options
From catalog date ........... 0000-00-00 00:00 (YYYY-MM-DD HH:II)
|
- Member
External program on user system file.
- Library
Library containing the external program.
- User system Fnr
Number of user system file.
- User system DBnr
Database containing the user system file.
- From catalog date
If you specify a date in this field, only XRef data created on or after the date specified will be unloaded.
To unload XRef data from the transfer medium, enter command
UNLOAD OBJECTTYPE XR <parameters>
| Keyword | Field | Position |
|---|---|---|
| MEM | Member | 1 |
| LIB | Library | 2 |
| FNR | User system Fnr | 3 |
| DBNR | User system DBnr | 4 |
| FROM-DATE | From catalog date | 5 |
| TARGET | Target environment | 6 |
| CREATE-RT | Create Report Listing | 7 |
The workfile can be defined with Command SET. The default workfile is workfile 1.
See the sample unload command. Command:
UNLOAD EXTRACT <parameters>
This command unloads up to 10 extracts in migrate format. At least one extract must be specified; all parameters are optional.
| Keyword | Field | Position |
|---|---|---|
| EXTRACT1 | No. 1 Extract ID | 1 |
| EXTRACT2 | No. 2 Extract ID | 2 |
| EXTRACT3 | No. 3 Extract ID | 3 |
| EXTRACT4 | No. 4 Extract ID | 4 |
| EXTRACT5 | No. 5 Extract ID | 5 |
| EXTRACT6 | No. 6 Extract ID | 6 |
| EXTRACT7 | No. 7 Extract ID | 7 |
| EXTRACT8 | No. 8 Extract ID | 8 |
| EXTRACT9 | No. 9 Extract ID | 9 |
| EXTRACT10 | No. 10 Extract ID | 10 |
| CODE | With code | 11 |
| PROFILE | With profile | 12 |
| WITH-ET | Include Extracts | 13 |
| INTERNAL-ID | With internal ID | 14 |
| TARGET | Target environment | 15 |
| CREATE-RT | Create Report Listing | 16 |
Enter the following command to unload
all metadata created since January 1, 1997
retrieval model AL for object types program and system
XRef data for file number 99 on database 123
objects contained in Extracts EXT-1 and EXT-2, together with
any Predict-owned external objects connected to Files contained in the Extracts
the Predict and LIST XREF profiles of any Users contained in the Extracts
UNLOAD METADATA ALL,FROM-DATE=2013-05-31_00:00 UNLOAD RETRIEVALMODEL PR,ID=AL UNLOAD RETRIEVALMODEL SY,ID=AL UNLOAD OBJECTTYPE XR,FNR=99,DBNR=123 UNLOAD EXTRACT EXTRACT1=EXT-1,EXTRACT2=EXT-2,CODE=Y,PROFILE=Y |
See also section Data Transfer Examples in this documentation.
If you are working with more than one FDIC file, it is strongly recommended that you consolidate the Internal IDs of the objects at your site. After you have unloaded the objects you wish to consolidate, execute the function Load Internal ID as described on Importing Internal IDs.
You can unload the Internal IDs of all objects or any subset of objects. However, it is not possible to load selectively. All objects on the transfer medium are loaded with their internal IDs.
See also Consolidating Internal IDs in Batch Mode.
Enter code U and object type I in the Coordinator main menu.
Only parameters Extract ID, Include Extracts and Target environment are applicable.
Internal IDs can be unloaded with the command
UNLINTERNAL in library SYSDICBE. See
Sample
Batch Command.