GetDynamicString PowerScript function

Description

Obtains data of type String 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>.GetDynamicString</span> ( <span>index</span> )

Argument	Description
DynamicDescriptionArea	The name of the DynamicDescriptionArea, usually SQLDA.
index	An integer identifying the output parameter descriptor from which you want to get the data. Index must be less than or equal to the value in NumOutputs in DynamicDescriptionArea.

Return Values

String. Returns the string data in the output parameter descriptor
identified by index in DynamicDescriptionArea.
Returns the empty string ("")
if an error occurs. If any argument’s value is null, GetDynamicString returns null.

Usage

Use GetDynamicString when the value of
OutParmType is TypeString! for the value that you want to retrieve
from the array.

Examples

These statements set LName to the String data in
the second output descriptor:

1	String LName

1	LName = SQLDA.<span>GetDynamicString</span>(2)

For an example of retrieving data from the DynamicDescriptionArea,
see GetDynamicDate.

Connection Information

GetDynamicString – PB Docs 125