Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

Default language.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Unload for Db2 13.1.

NULLTYPE

This option allows you to specify the location and length of the null indicator field in the output record. 

GUID-9A4BDAC1-293B-42CF-9095-9DE8177E56AB-low.png

This option is intended to facilitate compatibility with the UNLOAD PLUS for DB2 product. 

The following table describes the values that you can specify for this option:

Values for the NULLTYPE option

Value

Description

T1

(default) Specifies that the null indicator is 1-byte long and trailing

T2

Specifies that the null indicator is 2-bytes long and trailing

L1

Specifies that the null indicator is 1-byte long and leading

L2

Specifies that the null indicator is 2-bytes long and leading

You can use the NULLCHAR option instead of the NULLTYPE option. If you specify both the NULLTYPE and NULLCHAR options:

  • The highest string value determines the null indicator length.
  • The location value of the second option determines the null indicator position.

If the null indicator string value is 1-byte long, specifying NULLTYPE T2 or L2 duplicates it.

Information
Example

The following example results in a trailing, 2-byte null indicator ('??'):

NULLCHAR('?',LEADING) NULLTYPE T2

The resulting string value is '??' because NULLTYPE T2 duplicates the 1-byte NULLCHAR string value ('?').

The resulting position is trailing because NULLTYPE T2, which specifies a trailing null indicator, is the second option.

Information
Example

The following example results in a leading, 2-byte null indicator:

NULLCHAR('?$',TRAILING) NULLTYPE L1

The resulting string value is 2-bytes long because the 2-byte string value in the NULLCHAR option ('?$') is higher than the 1-byte determined by NULLTYPE L1.

The resulting position is leading because NULLTYPE T1, which specifies a trailing null indicator, is the second option.

Information
Example

The following example results in a trailing null indicator of X'FFFF':

NULLTYPE L2 NULLCHAR(X'FF',TRAILING)

The resulting string value is 2-bytes (X'FFFF') because NULLTYPE L2 duplicates the 1-byte NULLCHAR string value (X'FF').

Considerations

The following considerations apply to the NULLTYPE option:

  • If you specify SPANNED YES, this value applies only to the base table space. The LOB data will have a leading null indicator of X'FF' regardless of the value that you specify for this option.
  • BMC AMI Unload ignores this option if you also specify FORMAT UNLOAD.

Related topics

BMC AMI Unload option descriptions
BMC-AMI-Unload-Option-descriptions

UNLOAD-syntax-diagrams



 

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

BMC AMI Unload for Db2 12.1