Expressions in SPL routines

You can use any SQL expression in an SPL routine, except for an aggregate expression. The 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)