Skip to Content

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.

Unloading a specific number of rows

In the following example, BMC AMI Unload stops unloading at 25,000 rows:

//SYSIN DD *
UNLOAD
LIMIT 250 FORMAT UNLOAD UNLOADDN(SYSREC)
SELECT *
FROM TXE.TXET01_D80S01 ;

Related topics

FORMAT UNLOAD

LIMIT 

 

 

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

BMC AMI Unload for Db2 12.1