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.
Table 1. JDBC adapter functions and commands
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