Argument types
When arguments are passed into an nzLua UDX they are translated into nzLua datatypes.
The table below contains the list of the standard nzLua data types that are in the ARGTYPE array
(see ARGCOUNT)).
| nzLua Datatype | Netezza Datatype |
| TYPE_BIGNUM | BIGINT, NUMERIC larger than 15 digits. The getOptions() method can be used to change the behavior for when values are passed into nzLua as bignum vs. numbers. |
| TYPE_BOOL | Boolean |
| TYPE_DATE | Date, Timestamp (nzLua translates both DATE and TIMESTAMP into unixtime). |
| TYPE_INTERVAL | Interval |
| TYPE_NUMBER | BYTEINT, SMALLINT, INTEGER, some BIGINT, some NUMERIC. For BIGINT/NUMERIC values, large numbers that cannot fit into a DOUBLE value will be passed into nzLua as TYPE_BIGNUM. |
| TYPE_STRING | CHAR and VARCHAR |
| TYPE_TIMESTAMP | Date, Timestamp (nzLua translates both DATE and TIMESTAMP into Unixtime). |
| TYPE_UTF8STRING | NCHAR and NVARCHAR |