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
Define and use variables
Declare local variables
Declare variables for column data with the LIKE clause

Declare variables for column data with the LIKE clause

If you use the LIKE clause, the database server defines a variable to have the same data type as a column in a table or view.

If the column contains a collection, row type, or nested complex type, the variable has the complex or nested complex type defined in the column.

In the following figure, the variable loc1 defines the data type for the locations column in the image table.

Figure 1: Define the loc1 data type for the locations column in the image table.

DEFINE loc1 LIKE image.locations;