Programming with Reflection

image\rwnprg32.gif GetSQLStatement method

 

Syntax Statement = object.GetSQLStatement(Type)

 

Description

Returns a portion of the current SQL query. The returned string is the complete, current query for the specified query type. This method applies to AS/400 data transfer only, and is only relevant during 5250 sessions.

Arguments

Type Argument type:
Argument type: Enumeration
Specifies an SQL query type. Possible values are :

 rcAS400Select
rcAS400Where
rcAS400OrderBy
rcAS400Having
rcAS400GroupBy
rcAS400JoinBy

 See SetSQLStatement for additional information about these values.

Return

Statement Return type: String
The portion of the current SQL statement specified by Type.

 

image\jump.gif Example

image\jump.gif Keyword Index

image\popup.gif Related Topics

image\popup.gif Reflection products that use this command