The table displays a list of functions in alphabetical order in Connect CDC (SQData).
| Function name | Category |
|---|---|
| @BEFORE | Change Data Capture (CDC) |
| ABS | Mathematical |
| ADD | Mathematical |
| AFTER | Date and Time |
| AND | Boolean |
| B2D | String |
| B2X | String |
| BEFORE | Date and Time |
| BETWEEN | Boolean |
| BITCHR | String |
| BLENGTH | Byte |
| BRECLEN | Byte |
| BSEARCH | Byte |
| C2X | String |
| CALLPROC | Specialized |
| CALL function PROC | Specialized |
| CASE | Specialized |
| CDCBEFORE | Change Data Capture |
| CDCEPOCH | Change Data Capture |
| CDC_METADATA | Change Data Capture |
| CDC_SET_METADATA | Change Data Capture |
| CDCOP | Change Data Capture |
| CDCRAW | Change Data Capture |
| CDCSTCK | Change Data Capture |
| CDCTSTMP | Change Data Capture |
| CDCTSTMPPK | Change Data Capture |
| CDCUID | Change Data Capture |
| CDCUUID | Change Data Capture |
| CDCUOW | Change Data Capture |
| CLEAR_RECORD | Change Data Capture |
| CONVERT_CCISD | Specialized |
| DATE2SMALLJUL | Date and Time |
| DATEFMT | Date and Time |
| DATETIME | Date and Time |
| DAY | Date and Time |
| DAYNAME | Date and Time |
| DAYOFWEEK | Date and Time |
| DAYS | Date and Time |
| DB2QUAL | Specialized |
| DB2TBLNAME | Specialized |
| DECREMENT | Mathematical |
| DIV | Mathematical |
| DSDIR | Specialized |
| DSNAME | Specialized |
| EQ | Mathematical |
| EXCLUDE | String |
| FIX | String |
| FLDCHG | Boolean |
| FLDCOUNT | Record |
| FLDMAX | Specialized |
| FLDMIN | Specialized |
| FLDNAME | Record |
| FLDNULL | Record |
| FLDTYPE | Record |
| FLDUPDATE | Record |
| FLDVALUE | Record |
| FULLKEY (IMS Fullkey) | Specialized |
| GE | Boolean |
| GENUUID | Change Data Capture |
| GET_RAW_RECORD | Record |
| GMT2LOCAL | Date and Time |
| GT | Boolean |
| HASH_LOAD | Specialized |
| HASH_REMOVE | Specialized |
| HASH_STORE | Specialized |
| IF / ELSE | Specialized |
| IFNULL | Specialized |
| IMSDBNAME | Specialized |
| IMSPGMNAME | Change Data Capture |
| IMSPSBNAME | Change Data Capture |
| IMSTRANNAME | Change Data Capture |
| INCREMENT | Mathematical |
| ISDEC | Boolean |
| ISINT | Boolean |
| ISNULL | Boolean |
| ISNUM | Boolean |
| ISREFRESH | Change Data Capture |
| ISTEXT | Boolean |
| JULIAN | Date and Time |
| JULIAN2DATE | Date and Time |
| LE | Boolean |
| LEFT | String |
| LENGTH | String |
| LOCAL2GMT | Date and Time |
| LOOP | Specialized |
| LOWER | String |
| LT | Boolean |
| LTRIM | String |
| MAP | Specialized |
| MAP_BEFORE | Specialized |
| MD5SUM_JSON | Specialized |
| MID | String |
| MOD | Mathematical |
| MONTH | Date and Time |
| MONTHNAME | Date and Time |
| MTRIM | String |
| MULTIPLY | Mathematical |
| NE | Boolean |
| NORM | Specialized |
| NOT | Boolean |
| NULL | Specialized |
| OFFSET_OF | Record |
| ONEOF | Boolean |
| OR | Boolean |
| OS | Specialized |
| OUTMSG | Specialized |
| RECIDENT | Specialized |
| RECNAME | Change Data Capture |
| REMAP | Record |
| RID | Specialized |
| RIGHT | String |
| ROUND | Mathematical |
| RTRIM | String |
| SEARCH | String |
| SECONDS | Date and Time |
| SETIMAGE | Specialized |
| SETURL | Specialized |
| SETURLKEY | Specialized |
| SMALLJUL | Date and Time |
| SMALLJUL2DATE | Date and Time |
| STRING | String |
| SUBTRACT | Mathematical |
| TERMINATE | Specialized |
| TIME | Date and Time |
| TIMESTAMP | Date and Time |
| TODAY | Date and Time |
| TO_DELIMITED | Format |
| TO_JSON | Format |
| TRANSLATE | String |
| TRIM | String |
| UPPER | String |
| WEEK | Date and Time |
| WHERE | Boolean |
| WORD | String |
| WORDS | String |
| X2B | String |
| X2C | String |
| YEAR | Date and Time |