| Home | Previous Lesson: Dynamic Staging Area Next Lesson: Format 1 |
The dynamic description area stores information about input and output parameters and is used with the fourth format of dynamic SQL. PowerBuilder provides a global-level dynamic description area named SQLDA, with the following structure:
|
Attributes |
Meaning |
|
SQLDA.NumInputs |
Number of input parameters |
|
SQLDA.InParmType |
Array of input parameter types |
|
SQLDA.NumOutputs |
Number of output parameters |
|
SQLDA.OutParmType |
Array of output parameter types |
The two principal statements of dynamic SQL are PREPARE and EXECUTE. The PREPARE statement takes the base SQL commands and places them in the SQLSA command buffer for execution. The EXECUTE statement passes these commands from the buffer to the back-end database and returns the feedback information to SQLCA as usual.
| Home | Previous Lesson: Dynamic Staging Area Next Lesson: Format 1 |