Format

The Format parameter specifies the format of SQL input statements.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[SQL]

Abbreviation

None

Required?

No

Valid values

Standard or Packed72

Default value

Packed72

Related topics

SQL-parameters

Preparing-and-sending-SQL-files

Usage

Specify Packed72 (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, the 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 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.

 

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