UNLOAD syntax that is no longer valid

The following UNLOAD options that were valid in the BMC UNLOAD PLUS product are not valid for use with BMC AMI Unload. The following table indicates whether BMC AMI Unload ignores the option or terminates.

Invalid option	BMC AMI Unload action
ACTIVE	Ignores
ANALYZE	Ignores
CENTURY	Terminates
CLONE	Terminates
CURRENTDEGREE	Ignores
DDLDDN	Terminates
DECFLOAT_ROUNDMODE	Terminates
DSPLOCKS	Ignores
ENUMROWS	Ignores
FORCE - all keywords except NONE	Terminates
FORMAT - all keywords except EXTERNAL, DSNTIAUL, and UNLOAD	Terminates
IF ERROR (on the field specification)	Terminates
IMPLICIT_TZ	Terminates
INTERVAL	Terminates
MAXBLKSIZE	Terminates
MAXCONNECT	Ignores
MAXSORTS	Ignores
ON FAILURE with RETCODE	Terminates
ON MESSAGE	Terminates
RECFM	Terminates
SET CURRENT QUERY ACCELERATION ALL	Terminates
SORTDEVT	Ignores
SORTNUM	Ignores
SYNC	Ignores
UNLOADEXIT	Terminates
USELRECL	Terminates
WTOMSG	Ignores
XBMID	Ignores
ZIIP	Ignores

UNLOAD syntax that is no longer valid

BMC AMI Unload for Db2 13.1

On this page