Use the following BTEQ commands to control SQL:
DECIMALDIGITS |
AUTOKEYRETRIEVE |
SQL Function |
BTEQ Command |
Override the precision specified by a CLI System Parameter Block (SPB) max_decimal_returned entry, or if that entry does not exist, indicate what the precision should be for decimal values associated with subsequently issued SQL requests for non-Field Mode responses. |
DECIMALDIGITS |
Enable users to specify whether the values of any fields associated with Identity Data are returned in response to an SQL Insert operation. |
AUTOKEYRETRIEVE |