GET function

The GET function returns the data from the source adapter.

With Database/Query File Without Database/Query File

GET ("DB",
"-MDQ mdq_file
-DBNAME database_name
-QUERY query_name|-STMT SQL_stmt
[-FILE [directory]]
[-VAR name=value...]
[-USER username]
[-PASSWORD password]
[-CCARD|-CSTMT [number]]
[-ROWCNT row_count]
[-AUDIT[G][+] [full_path]]
[{-TRACE|-TRACEERR}[+] [full_path]]")

GET "DB",
"-DBTYPE OLEDB
-SOURCE datalink
-STMT SQL_stmt
[-FILE [directory]]
[-USER username]
[-PASSWORD password]
[-ROWCNT row_count]
[-CCARD|-CSTMT [number]]
[-AUDIT[G][+] [full_path]]
[{-TRACE|-TRACEERR}[+] [full_path]]")