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 |
<span>DynamicDescriptionArea</span><span>.GetDynamicDecimal</span> ( <span>index</span> ) |
|
Argument |
Description |
|---|---|
|
DynamicDescriptionArea |
The name of the DynamicDescriptionArea, |
|
index |
An integer identifying the output parameter descriptor |
Return Values
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 |
Integer DeptId |
|
1 |
DeptId = SQLDA.<span>GetDynamicDecimal</span>(2) |
For an example of retrieving data from the DynamicDescriptionArea,
see GetDynamicDate.