DDLIN data sets in UNLOAD PLUS

This optional data set, which you might use with the INFILE ddname option, contains the DDL that defines all of the objects that are related to the table from which UNLOAD PLUS unloads rows.

UNLOAD PLUS uses the DDL in the DDLIN data set for Db2 object definitions instead of using object definitions in the Db2 catalog.

Related topics

UNLOAD-PLUS-data-sets

UNLOAD-PLUS-DD-statements

Requirements

Note the following requirements when using a DDLIN data set:

  • You must specify the attributes of this data set as fixed length (RECFM is F, FB, or FBS), and the record length must be 80 bytes (the logical record length or LRECL=80). UNLOAD PLUS uses only columns 1 through 72.
  • The data set must contain the following DDL for all objects that are related to the table from which UNLOAD PLUS is unloading rows:
    • CREATE DATABASE
    • CREATE TABLESPACE
    • CREATE TABLE
    • CREATE INDEX
  • The DDL in the DDLIN data set must match the definition of the object that you are unloading.
  • If either of the following conditions exists, you must specify the OBID of the table, either on each CREATE TABLE statement in the DDLIN data set or with each SELECT statement:
    • You specify multiple SELECT statements.
    • You are unloading a table space which currently is or previously was a multi-table table space.

Restrictions

The following restrictions apply to using a DDLIN data set:

  • If you specify LOGICAL PART on your UNLOAD command, UNLOAD PLUS ignores the LOGICAL keyword and considers the specified partitions to be physical partitions.
  • DDL in the DDLIN data set has the following restrictions:
    • UNLOAD PLUS does not support the following syntax and ignores these statements in the DDLIN data set:
      • Syntax to create materialized query tables (MQTs)
      • CREATE VIEW statements
      • ALTER DDL statements
      • Syntax to create clone tables
    • Character, hexadecimal, binary, and graphic string constants are limited to a length of 255 bytes.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*