d

driver

JDBC_DRIVER

jdbc driver class

true

c

connection

JDBC_CONN

jdbc connection string

true

u

username

USERNAME

database username

true

p

password

PASSWORD

database password

true

o

output

CONFIG_FILE

config file for output record handler

true

O

outputOverride

VALUE

override the RH_PARAM of output record handler using VALUE

false

t

tableName

TABLE_NAME

a single database table name [have multiple -t for more table names]

false

Q

query

SQL_QUERY

use SQL_QUERY to select from TABLE_NAME

false

I

id

ID_FIELD_LIST

use columns in ID_FIELD_LIST [comma separated] as identifier for TABLE_NAME

false

F

fields

FIELD_LIST

fetch columns in FIELD_LIST comms [comma separated] for TABLE_NAME

false

R

relations

RELATION_PAIR_LIST

fetch columns in RELATION_PAIR_LIST [comma separated] for TABLE_NAME

false

W

whereClause

CLAUSE_LIST

filter TABLE_NAME records based on conditions in CLAUSE_LIST [comma separated]

false

T

tableFromClause

TABLE_LIST

add tables to use in from clauses for TABLE_NAME

false

delimiterPrefix

DELIMITER

Prefix each field in the query with this character

false

delimiterSuffix

DELIMITER

Suffix each field in the query with this character

false