Format
The Format parameter specifies the format of SQL input statements.
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [SQL] |
Abbreviation | None |
DBMS | Db2, Db2 LUW, Oracle |
Required? | No |
Valid values | Standard or Packed72 |
Default value |
|
Usage
Specify the format of the SQL statements that will serve as input for the apply request.
Specify Standard if your input is coming from Oracle or Db2 LUW for UNIX or Windows.
Standard refers to a format of SQL variable-length statements. This value indicates that the input file contains regular SQL with statements on one or more lines. (Quoted strings cannot span multiple lines.)
Specify Packed72 if your input is coming from a mainframe source. (Most SQL from mainframe sources is generated in fixed-length data sets.) This format is compatible with the Db2 SPUFI utility. If the file does not match this format, results are unpredictable.
Packed72 refers to a format of SQL fixed-length records which are in packed 72 bytes. This format indicates that the input file contains SQL was generated by BMC AMI Log Master for Db2 on a mainframe source or formatted by the user. This format is processed as though all rows in the file are 72 bytes long and quoted strings can span multiple lines.
Related topics