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