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 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