TypeOf
The TypeOf function returns the xSQL data type id for the given input parameter.
Syntax
TypeOf(<value or expression>) |
Return Type
Integer
Details
The TypeOf function is mostly for internal Xactly use. End users and developers will find the TypeNameOf to be more useful. Use the SHOW TYPES command to see the list of available data types within Connect.
Examples
eval TypeOf('Woolly mammoth');
select TypeOf(employee_id), TypeOf(participant_id), TypeOf(first_name), TypeOf(salary), TypeOf(effective_start_date) from xactly.xc_participant limit 1;
Related Functions