List of commands
The following table lists each database-specific adapter command and whether the command can be used for a source or target, or in a DBLOOKUP, DBQUERY, GET, or PUT function. Usage is indicated with ✓. For a RUN function, any adapter command can be used as indicated for a source or target.
| Name | Adapter Command Syntax | Source | Target | DBLOOKUP DBQUERY | GET | PUT |
|---|---|---|---|---|---|---|
| Audit (-A or -AUDIT) | -AUDIT[G][+] [full_path] | ✓ | ✓ | ✓ | ✓ | ✓ |
| Bad Data (-BD or -BADDATA) | -BADDATA[+] full_path | ✓ | ✓ | |||
| Connect String (-C or -CONNECT) (Oracle only) | -CONNECT connect_string | ✓ | ✓ | ✓ | ✓ | ✓ |
| Commit by Card (-CC or -CCARD) * | -CCARD | ✓ | ✓ | ✓ | ✓ | ✓ |
| Commit by Statement (-CS or -CSTMT) | -CSTMT [number] | ✓ | ✓ | ✓ | ✓ | ✓ |
| Delete (-D or -DELETE) | -DELETE | ✓ | ✓ | |||
| Database Name (-DN or -DBNAME) * | -DBNAME database_name | ✓ | ✓ | ✓ | ✓ | ✓ |
| Database Adapter Type (-DT or -DBTYPE) | -DBTYPE database_adapter | ✓ | ✓ | ✓ | ✓ | ✓ |
Data Source (-DS or -SOURCE)
|
|
✓ ✓ |
✓ ✓ |
✓ ✓ |
✓ ✓ |
✓ ✓ |
| File (-F or -FILE) | -FILE [directory] | ✓ | ✓ | |||
| Global Transaction Management (-GTX) (Oracle, Oracle AQ, Microsoft™ SQL Serveronly) | -GTX | ✓ | ✓ | ✓ | ✓ | ✓ |
| Database/Query File (-M or -MDQ) * | -MDQ mdq_file_name | ✓ | ✓ | ✓ | ✓ | ✓ |
| Password (-PW or -PASSWORD) | -PASSWORD password | ✓ | ✓ | ✓ | ✓ | ✓ |
| Stored Procedure Name (-PR or -PROC) | -PROC procedure_name | ✓ | ✓ | |||
| Query (-Q or -QUERY) | -QUERY query_name | ✓ | ✓ | |||
| Row Count (-RC or -ROWCNT) (ODBC, Oracle, DB2®) | -ROWCNT row_count | ✓ | ✓ | ✓ | ||
| SQL Statement (-S or -STMT) | -STMT SQL_statement | ✓ | ✓ | |||
| Table Name (-TB or -TABLE) * | -TABLE table_name | ✓ | ✓ | |||
| Trace (-T or -TRACE) | -TRACE[+] [full_path] | ✓ | ✓ | ✓ | ✓ | ✓ |
| Trace Error (-TE or -TRACEERR) | -TRACEERR[+] [full_path] | ✓ | ✓ | ✓ | ✓ | ✓ |
| Trigger (-TR or -TRIG) (Oracle, Microsoft™ SQL Server only) | -TRIG trigger_string | ✓ | ||||
| Update (-UP or -UPDATE) | -UPDATE [OFF|ONLY] | ✓ | ✓ | |||
| User ID (-US or -USER) | -USER user_ID | ✓ | ✓ | ✓ | ✓ | ✓ |
| Variable (-V or -VAR) | -VAR name=value... | ✓ | ✓ | ✓ |
*A card setting exists. Using the adapter command will override any value set in the corresponding card setting. For examples, refer to Command Line Examples.