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 | ✓ | ✓ | ✓ | ✓ |
-USER user_name | ✓ | ✓ | ✓ | ✓ | |
-PASSWORD password | ✓ | ✓ | ✓ | ✓ | |
-DRIVER driver_class | ✓ | ✓ | ✓ | ✓ | |
-AUTOCOMMIT {default | on | off} | ✓ | ✓ | ✓ | ✓ | |
Identify a database table or columns or stored procedure | -CATALOG catalog_name | ✓ | ✓ | ✓ | ✓ |
-SCHEMA schema_name | ✓ | ✓ | ✓ | ✓ | |
-PROCEDURE procedure_name | ✓ | ✓ | ✓ | ✓ | |
-TABLE table_name | ✓ | ✓ | ✓ | ✓ | |
-COLUMNS column [, column [, …]] | ✓ | ✓ | ✓ | ✓ | |
Define how to write to or fetch from a database | -WRITEMODE {insert | insert_first | update | update_first} | ✓ | ✓ | ||
-QUERY statement_text | ✓ | ✓ | ✓ | ||
-QUERYFILE query_file | ✓ | ✓ | ✓ | ||
-DML statement_text | ✓ | ✓ | |||
-DMLFILE dml_file | ✓ | ✓ | |||
-KEY name[,name [, …]] | ✓ | ✓ | ✓ | ||
-BIND index[type][,index[type] [, …]] | ✓ | ✓ | ✓ | ||
-ROWLIMIT row_limit | ✓ | ✓ | ✓ | ✓ | |
-NAMEDPARAMS | ✓ | ✓ | ✓ | ✓ | |
-EXCLUDEREADONLY | ✓ | ✓ | ✓ | ✓ | |
-SETCOLUMNS column [, column [, …]] | ✓ | ✓ | |||
-USECOLUMNLABELS | ✓ | ✓ | ✓ | ✓ | |
-TRUNCATE | ✓ | ✓ | |||
-MISSINGVALUEMODE { null_value | empty_string} | ✓ | ✓ | ✓ | ✓ | |
-LSN seconds | ✓ | ✓ | |||
Configure SQL statements to run before or after fetching records from the database | -PRESQL statement_text | ✓ | ✓ | ✓ | ✓ |
-PRESQLFILE pre_sql_file | ✓ | ✓ | ✓ | ✓ | |
-POSTSQL statement_text | ✓ | ✓ | ✓ | ✓ | |
-POSTSQLFILE post_sql_file | ✓ | ✓ | ✓ | ✓ | |
Specify the number of rows to fetch from or send to the database | -FETCHSIZE fetch_size | ✓ | ✓ | ||
-BATCHSIZE batch_size | ✓ | ✓ | |||
-QTY quantity | ✓ | ✓ | |||
Identify the table where the adapter stores invalid input records | -ERRORROWHANDLING {none | error_table | error_file} | ✓ | ✓ | ✓ | |
-ERRORCATALOG catalog_name | ✓ | ✓ | ✓ | ||
-ERRORSCHEMA schema_name | ✓ | ✓ | ✓ | ||
-ERRORTABLE table_name | ✓ | ✓ | ✓ | ||
-ERRORFILENAME error_file_name | ✓ | ✓ | ✓ | ||
-ERRORROWDATA | ✓ | ✓ | ✓ | ||
Specify character-set encoding | -CHARSET charset_name | ✓ | ✓ | ✓ | ✓ |
Configure adapter tracing | -T[E|V]?[+]? [file_name] | ✓ | ✓ | ✓ | ✓ |
Define how to write to or fetch from a database | ... | ||||
-READMODE {select_all|lookup } | ✓ | ||||
Specify the number of rows to fetch from or send to the database | ... | ||||
-ARRAYSIZE array_size | ✓ | ✓ |