Compressed columns

NZAE_COMPRESSED_COLUMNS

Controls the compressed column functionality of the AE system. Compressed columns allow more than one virtual column argument to be contained within a physical column argument to a scalar function or table function (does not apply to aggregate AEs) AE or UDX. Use this functionality to circumvent the Netezza appliance SQL function physical argument limitation of 64. This functionality is used along with the nzaemultiarg UDF, which is used to pack multiple SQL function column arguments into a single argument. Compressed columns are covered in greater detail in Using AEs to exceed NPS SQL function argument limits.

NZAE_COMPRESSED_COLUMNS={0 | 1}

When set to 1, the AE system looks for compressed columns and automatically unpacks a physical compressed physical column argument into multiple virtual column arguments. This transformation is transparent to an AE. The default setting is 0. When set to 0, the AE system ignores compressed columns and treats them as a single string column.