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 stored procedure | -CATALOG catalog_name | ✓ | ✓ | ✓ | ✓ |
-SCHEMA schema_name | ✓ | ✓ | ✓ | ✓ | |
-TABLE table_name | ✓ | ✓ | ✓ | ✓ | |
-PROCEDURE procedure_name | ✓ | ✓ | ✓ | ✓ | |
Define how to write to or fetch from a database | -WRITEMODE {insert | insert_first | update | update_first} | ✓ | ✓ | ||
-QUERY statement_text | ✓ | ✓ | ✓ | ||
-DML statement_text | ✓ | ✓ | |||
-KEY name[,name [, …]] | ✓ | ✓ | ✓ | ||
-BIND index[type][,index[type] [, …]] | ✓ | ✓ | ✓ | ||
-LSN seconds | ✓ | ✓ | |||
Configure SQL statements to run before or after fetching records from the database | -PRESQL statement_text | ✓ | ✓ | ✓ | ✓ |
-POSTSQL statement_text | ✓ | ✓ | ✓ | ✓ | |
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 | -ERRORCATALOG catalog_name | ✓ | ✓ | ✓ | |
-ERRORSCHEMA schema_name | ✓ | ✓ | ✓ | ||
-ERRORTABLE table_name | ✓ | ✓ | ✓ | ||
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 | ✓ | ✓ |