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)Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]