GetDynamicDecimal
PowerScript function
Description
Obtains numeric data from the DynamicDescriptionArea after you have
executed a dynamic SQL statement.
Restriction
You can use this function only after executing Format 4 dynamic
SQL statements.
Syntax
|
1 |
DynamicDescriptionArea.GetDynamicDecimal ( index ) |
|
Argument |
Description |
|---|---|
|
DynamicDescriptionArea |
The name of the DynamicDescriptionArea, usually |
|
index |
An integer identifying the output parameter descriptor |
Return value
Decimal.
Returns the numeric data in the output parameter descriptor
identified by index in DynamicDescriptionArea. Returns 0 if an error
occurs. If any argument’s value is null, GetDynamicDecimal returns
null.
Usage
Use GetDynamicDecimal when the value of OutParmType is TypeDecimal!
or TypeLongLong! for the value that you want to retrieve from the
array.
Examples
These statements set DeptId to the numeric data in the second output
parameter descriptor:
|
1 2 |
Integer DeptId DeptId = SQLDA.GetDynamicDecimal(2) |
For an example of retrieving data from the DynamicDescriptionArea,
see GetDynamicDate.
See also