JDBC adapter command overview
The following table lists the JDBC adapter commands by function, and specifies whether each
command is valid on input and output cards and GET and PUT functions.
| Function | Command | Input card | GET function | Output card | PUT function |
|---|---|---|---|---|---|
| Configure the JDBC connection and driver | -URL connection_string | ✓ | ✓ | ✓ | ✓ |
| -USERNAME | ✓ | ✓ | ✓ | ✓ | |
| -PASSWORD | ✓ | ✓ | ✓ | ✓ | |
| -DRIVER | ✓ | ✓ | ✓ | ✓ | |
| -AUTOCOMMIT {default | on | off} | ✓ | ✓ | ✓ | ✓ | |
| Identify a database table or columns or stored procedure | -CATALOG | ✓ | ✓ | ✓ | ✓ |
| -SCHEMA | ✓ | ✓ | ✓ | ✓ | |
| -PROCEDURE | ✓ | ✓ | ✓ | ✓ | |
| -TABLE | ✓ | ✓ | ✓ | ✓ | |
| -COLUMNS column [, column [, …]] | ✓ | ✓ | ✓ | ✓ | |
| Define how to write to or fetch from a database | -DATEFORMAT | ✓ | ✓ | ✓ | ✓ |
| -TIMEFORMAT | ✓ | ✓ | ✓ | ✓ | |
| -TIMESTAMPFORMAT | ✓ | ✓ | ✓ | ✓ | |
| -WRITEMODE {insert | insert_first | update | update_first} | ✓ | ✓ | |||
| -QUERY | ✓ | ✓ | ✓ | ||
| -QUERYFILE query_file | ✓ | ✓ | ✓ | ||
| -DML | ✓ | ✓ | |||
| -DMLFILE dml_file | ✓ | ✓ | |||
| -KEY | ✓ | ✓ | ✓ | ||
| -BIND | ✓ | ✓ | ✓ | ||
| -ROWLIMIT row_limit | ✓ | ✓ | ✓ | ✓ | |
| -NAMEDPARAMS | ✓ | ✓ | ✓ | ✓ | |
| -EXCLUDEREADONLY | ✓ | ✓ | ✓ | ✓ | |
| -SETCOLUMNS column [, column [, …]] | ✓ | ✓ | |||
| -USECOLUMNLABELS | ✓ | ✓ | ✓ | ✓ | |
| -TRUNCATE | ✓ | ✓ | |||
| -MISSINGVALUEMODE { null_value | empty_string} | ✓ | ✓ | |||
| -LSN | ✓ | ✓ | |||
| Configure SQL statements to run before or after fetching records from the database | -PRESQL | ✓ | ✓ | ✓ | ✓ |
| -PRESQLFILE pre_sql_file | ✓ | ✓ | ✓ | ✓ | |
| -POSTSQL | ✓ | ✓ | ✓ | ✓ | |
| -POSTSQLFILE post_sql_file | ✓ | ✓ | ✓ | ✓ | |
| Specify the number of rows to fetch from or send to the database | -FETCHSIZE | ✓ | ✓ | ||
| -BATCHSIZE | ✓ | ✓ | |||
| -QTY | ✓ | ✓ | |||
| Identify the table where the adapter stores invalid input records | -ERRORROWHANDLING {none | error_table | error_file} | ✓ | ✓ | ✓ | |
| -ERRORCATALOG | ✓ | ✓ | ✓ | ||
| -ERRORSCHEMA | ✓ | ✓ | ✓ | ||
| -ERRORTABLE | ✓ | ✓ | ✓ | ||
| -ERRORFILENAME error_file_name | ✓ | ✓ | ✓ | ||
| -ERRORROWDATA | ✓ | ✓ | ✓ | ||
| Specify character-set encoding | -CHARSET | ✓ | ✓ | ✓ | ✓ |
| -SQLFILESCHARSET | ✓ | ✓ | ✓ | ✓ | |
| Configure adapter tracing | -T[E|V]?[+]? [file_name] | ✓ | ✓ | ✓ | ✓ |
| Define how to fetch rows from a database (managed automatically by the adapter) | -READMODE {select_all|lookup } | ✓ | |||
| Specify the number of rows fetched from the database to concatenate and return as a single fetch unit (managed automatically by the adapter) | -ARRAYSIZE array_size | ✓ | ✓ |