Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Create and use SPL routines
Expressions in SPL routines

Expressions in SPL routines

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