There are eight categories of SQData functions, which include:
| Function | Description |
|---|---|
| Date / Time | Used for date and time manipulation and transformation. Some of the functions such as AFTER and BEFORE can be used to ‘age’ dates, which can be useful in creating test data. |
| String | Used to manipulate / transform character data strings. |
| Boolean | Used to determine whether or not a value and/or condition meet a certain criteria. All Boolean functions return either a true (1) or a false (0) value depending on the result of one (1) or more conditions tested. |
| Mathematical | Perform complex arithmetic on numeric data. |
| Specialized | Used to control runtime processing and/or perform certain operations that are useful in data transformation. |
| Changed Data Capture (CDC) | Used to extract information from the CDC records created by the SQData data capture agents. Refer to the SQData V4 Data Capture Guide and Reference manuals for more information regarding the data capture agents. |
| Format | Used to convert an entire source record to a specific format |
| Record | Used to perform operations on an entire source record |