DB2 Version 9.7 for Linux, UNIX, and Windows

BIND_VARIABLE_DATE procedure - Bind a DATE value to a variable

The BIND_VARIABLE_DATE procedure provides the capability to associate a DATE value with an IN, INOUT, or OUT argument in an SQL command.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_SQL.BIND_VARIABLE_DATE--(--c--,--name--,--value--)-----><

Parameters

c
An input argument of type INTEGER that specifies the cursor ID for the SQL command with bind variables.
name
An input argument of type VARCHAR(128) that specifies the name of the bind variable in the SQL command.
value
An input argument of type DATE that specifies the value to be assigned.

Authorization

EXECUTE privilege on the DBMS_SQL module.