Informix Guide to SQL: Tutorial Creating and Using 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)