Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Other syntax segmentsThese topics describe syntax segments, which are language elements, such as database object names or optimizer directives, that appear as a subdiagram reference in the syntax diagrams of some SQL or SPL statements.
Routine Parameter List
Using the LIKE Clause

Using the LIKE Clause

Use the LIKE clause to specify that the data type of a parameter is the same as a column defined in the database. If the ALTER TABLE statement changes the data type of the column, the data type of the parameter also changes.

In HCL OneDB™, if you use the LIKE clause to declare any parameter, you cannot overload the UDR. For example, suppose you create the following user-defined procedure:

CREATE PROCEDURE cost (a LIKE tableX.colY, b INT)
. . .
END PROCEDURE;

You cannot create another procedure named cost( ) in the same HCL OneDB database with two arguments. You can, however, create a procedure named cost( ) with a number of arguments other than two. (Another way to circumvent this restriction on the LIKE clause is through user-defined data types.)