Unload

#### Search Results

Search

# Unload

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:

- Calling the Online Function

- Unload Methods

- Unload Options

- Unloading Objects with Commands

- Unloading Metadata

- Unloading Retrieval Models

- Unloading XRef Data

- Unloading Extracts in Batch Mode

- Sample Unload Command

- Unloading Internal IDs

## Calling the Online Function

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. Metadata Y An additional screen appears in which you can specify the metadata to be unloaded. See Unloading Metadata. Retrieval models Y An additional screen appears in which you can specify the retrieval models to be unloaded. See Unloading Retrieval Models. XRef data Y An additional screen appears in which you can specify the XRef data to be unloaded. See Unloading XRef Data.

## Unload Methods

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.

## Unload Options

### With Code

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.

### With Profile

Applies to objects of type user: If this parameter is set to Y, Predict and LIST XREF profiles are unloaded, too.

### With Internal ID

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.

### Include Extracts

If this parameter is set to Y, the extract(s) used for the Unload function will also be unloaded.

### Target Environment

Data can be unloaded to the following environments:

- 85
  Predict 8.6 Data is unloaded in Migrate 8.5 format.

- 86
  Predict 8.6 Data is unloaded in Migrate 8.6 format.

### Create Report Listing

If this parameter is set to Y (default), a report listing of type UNL is created on the Main FDIC.

## Unloading Objects with Commands

With Unload commands you can unload objects of different types selectively. The command used depends on the object type.

- Specifying the Object Type

- Unloading All Object Types

- Unloading Databases, Dataspaces, Files

- Unloading Keywords, Methods, Nodes, Properties, Servers, Triggers, User-Defined Object Types

- Unloading Interfaces, Library Structures

- Unloading Networks, Storagespaces, Virtual Machines

- Unloading Packagelists, Programs, Systems

- Unloading File Relations

- Unloading Users

- Unloading Verifications

### Specifying 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.

### Unloading All Object Types

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

### Unloading Databases, Dataspaces, Files

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

### Unloading Keywords, Methods, Nodes, Properties, Servers, Triggers, User-Defined Object Types

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

### Unloading Interfaces, Library Structures

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

### Unloading Networks, Storagespaces, Virtual Machines

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

### Unloading Packagelists, Programs, Systems

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

### Unloading File Relations

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

### Unloading Users

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

### Unloading Verifications

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

## Unloading Metadata

### Calling the Online Function

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)

#### Object type

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.

#### From date

If you specify a date in this field, only metadata created on or after the date specified will be unloaded.

### Command

    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

## Unloading Retrieval Models

### Calling the Function

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.

### Unloading Retrieval Models in Batch Mode

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

## Unloading XRef Data

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.

### Calling the Function

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.

### Unloading XRef Data in Batch Mode

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

## Unloading Extracts in Batch Mode

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

## Sample Unload Command

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.

## Unloading Internal IDs

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.

### Calling the Online Function

Enter code U and object type I in the Coordinator main menu.

Only parameters Extract ID, Include Extracts and Target environment are applicable.

### Unloading Internal IDs in Batch Mode

Internal IDs can be unloaded with the command `UNLINTERNAL` in library SYSDICBE. See Sample Batch Command.

### On this page

- Calling the Online Function
- Unload Methods
- Unload Options
- Unloading Objects with Commands
- Unloading Metadata
- Unloading Retrieval Models
- Unloading XRef Data
- Unloading Extracts in Batch Mode
- Sample Unload Command
- Unloading Internal IDs