GET function

The GET function returns the data from the source adapter.

Using GET with a database/query file:

GET (''DB'', ''
-MDQ DDNAME  
-DBNAME database_name  
-QUERY query_name|-STMT SQL_stmt
[-VAR name=value...]
[-CCARD|-CSTMT [number]
[{-TRACE [file|ERROR]}]'')

Using GET without a database/query file:

GET ''DB'', ''
-DBTYPE ODBC 
-STMT SQL_stmt 
[-SOURCE datasource]   
[-CCARD|-CSTMT [number]]   
[{-TRACE [file|ERROR]}]'')