IBM® Informix® 12.10

Expressions in SPL routines

You can use any SQL expression in an SPL routine, except for an aggregate expression. The IBM® Informix® Guide to SQL: Syntax provides the complete syntax and descriptions for SQL expressions.

The following examples contain SQL expressions:
var1
var1 + var2 + 5
read_address('Miller')
read_address(lastname = 'Miller')
get_duedate(acct_num) + 10 UNITS DAY
       fname[1,5] || ''|| lname '(415)' || get_phonenum(cust_name)
Parent topic: Create and use SPL routines

Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.