Defining a parameter

If your CCL statements uses parameters, the parameters must be defined in the Parameters table under the Parameters tab, where you can set the name and data type for each parameter.

To define a parameter, enter its name in the Name column and its type in the Type column.

To set a default value for the parameter, specify it in the Default column. This default value may be overridden by setting the Value column in the Bindings tab, as explained below.

If you need to define more than one parameter, use the Insert row button to the right of the Parameters table to add extra rows to the Parameters table. To delete unneeded rows, click on the Delete row button. To move parameter definitions up or down in the Parameters table, use the Move row up and Move row down buttons.


Created March 8, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com