SQL iQuery™ Built-in Functions
The SQL iQuery Script has a large library of built-in functions. These functions can be used in a way similar to RPG IV built-in functions. Unlike RPG IV, however, no percent sign is needed to specify the built-in function name. Click on the link in the table below to view the online help for that iQuery built-in function.
Visit the SQL iQuery Product Information Page
Note that SQL iQuery Script Built-in Functions are not SQL UDF functions. They are a inline code that is preformed when the script statement is processed.
Note: You can scroll through this table using your mouse roller/scroll wheel. Likewise, you can sort it by any column by clicking on the title of the column. Oh, and FYI, this HTML Scrolling Table is included in SQL iQuery at no additional cost.
| BuiltIn Function | |
|---|---|
| arr_string.html | |
| dtaara.html | |
| elem.html | |
| findfirstnotof.html | |
| findfirstof.html | |
| fkey.html | |
| getfile.html | |
| icomp.html | |
| isdigits.html | |
| isAlpha.html | |
| isBrowser.html | |
| isDefined.html | |
| isEmpty.html | |
| isInteract.html | |
| isWeb.html | |
| length.html | |
| msgid.html | |
| scan.html | |
| split.html | |
| sst.html | |
| sysval.html | |
| toASCII.html | |
| toHex.html | |
| toUpperLower.html | |
| trimleft.html | |
| trimRight.html | |
| usrspc.html | |
| xlate.html | |
| Edit.html | |
| 29 records retrieved. |
Check out SQL iQuery for yourself. Download our free trial today.