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 Dynamic Server, 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 Dynamic Server 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.)