DynamicStagingArea object

DynamicStagingArea is a PowerBuilder system object that stores information for use in dynamic SQL statements.

The DynamicStagingArea object is the only connection between the execution of a statement and a Transaction object and is used internally by PowerBuilder. You cannot access information in DynamicStagingArea, and there are no properties associated with DynamicStagingArea.

PowerBuilder provides a global DynamicStagingArea variable named SQLSA that you can use when you need a DynamicStagingArea variable. If necessary, you can declare and create additional variables of this type using this system object as the datatype.

For more information about using dynamic SQL, see the section called “Using dynamic SQL” in PowerScript Reference.

Properties

DynamicStagingArea property

DataType

Description

ClassDefinition

PowerObject

An object of type PowerObject containing information about the class definition of the object or control


Events

DynamicStagingArea event

Occurs

Constructor in PowerScript Reference

Immediately before the Open event occurs

Destructor in PowerScript Reference

Immediately after the Close event occurs


Functions

DynamicStagingArea function

Datatype returned

Description

ClassName in PowerScript Reference

String

Returns the name assigned to the object

GetContextService in PowerScript Reference

Integer

Creates a reference to a context-specific instance of the specified service

GetParent in PowerScript Reference

PowerObject

Returns a reference to the name of the parent object

PostEvent in PowerScript Reference

Boolean

Adds the specified event to the end of the message queue for the object

TriggerEvent in PowerScript Reference

Integer

Triggers a specified event in the object and executes the script for the event

TypeOf in PowerScript Reference

Object

Returns the type of the object