Using scalar_function method to specify result details
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
Use this method to define a scalar function with specific values for the precision, scale, and length of the result of the scalar function. The length, precision, and scale of the result of the scalar functions can be explicitly defined or set to DAM_NOT_SET to use the defaults. Default values are indicated in the description of the arguments in Table: Operator Types for Conditions.
For details on setting the length, precision, and scale, refer to the corresponding fields in the OA_COLUMNS table in Schema Definition and Management of the OpenAccess SDK Programmer's Guide.
scalar_function(
String sName,
int iConstantFunc,
String pfScalarFunc,
int iResXoType,
int iLength,
int iPrecision,
int iScale,
int iNumInputParams)
Parameters for scalar_function When Specifying Result Details
| Parameter | Type | Description |
| INPUT | ||
| sName | String | The name of the scalar function. |
| iConstantFunc | int | Indicates whether the function has constant output. 1 - indicates that the function is a constant scalar function and is evaluated only once per query if all its arguments are literal values. 0 - indicates that the function is a variable scalar function and therefore should be evaluated once per record during the dam_isTargetRow call, regardless of the input. |
| pfScalarFunc | String | The method in the IP that is to be called to execute this scalar function. |
| iResXoType | int | The data type of the result value of the scalar function. |
| iLength | int | The length of the result value of the scalar function. Set to DAM_NOT_SET to accept the following default values: CHAR, BINARY: 255 WVARCHAR: 16000 VARCHAR, VARBINARY: 8000 LONGVARCHAR, LONGVARBINARY: 1000000 WLONGVARCHAR: 2000000NUMERIC: 34 Other types: Default values as specified in OA_COLUMNS. |
| iPrecision | int | The precision of the result value of the scalar function. Set to DAM_NOT_SET to accept the following default values: CHAR, WCHAR, BINARY: 255 VARCHAR, WVARCHAR, VARBINARY: 8000 LONGVARCHAR, WLONGVARCHAR, LONGVARBINARY: 1000000 NUMERIC: 32 Other types: Default values as specified in OA_COLUMNS. |
| iScale | int | Scale of the result value of the scalar function.Set to DAM_NOT_SET to accept the following default value: NUMERIC: 5 Other types: Default values as specified in OA_COLUMNS. |
| iNumInputParams | int | The number of arguments expected by the function. >=0 to allow fixed argument list. < 0 to allow variable argument list with a maximum of |args|. |
| RETURN | ||
| NONE | ||