Chapter 12 DBMS-Specific Features


Database package parameters

Database package procedures (see Database package procedures) and cursors (see Database package cursors) can use input and output parameters.

For example, in a CREDIT procedure, you could define the parameters Account Number and Amount.

Parameters have the following properties:

Property Description
Name The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users.
Code The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces.
Comment Additional information about the parameter.
Parent Specifies the database package parent of the parameter. You can see the database package property sheet by clicking the Properties tool at the right of the field.
Data type Data type of the parameter. You can use the Question Mark button to display the list of Standard Data Types.
Default Value Default value of the parameter.
Parameter type Type of the parameter.

 


Copyright (C) 2008. Sybase Inc. All rights reserved.