Use Case

Sample setting for Z/OS

The following is an example of ini files used to drop and create schemas, drop and create tables, and loading CSV data in POSTGRESQL.

config.ini

[Database - cnxPostgreSQL1] 
adminDataBaseName=postgres 
adminDataBaseUser=postgres 
adminDataBasePassword=xxxxx 
dataBaseHost=localhost 
dataBasePort=5432 
dataBaseName=mydb 
dataBaseUser=myuser 
dataBasePassword=xxxxx
stepDatabaseKillDropCreate=true

all.ini

[Global] 
multithread=5 
[ExecuteSql - Execute configuration queries] 
database=cnxPostgreSQL1 
input.folder=database/config 
multithread=1 
[ExecuteSql - Drop schemas] 
database=cnxPostgreSQL1 
input.folder=database/schemas-drop 
multithread=1 
[ExecuteSql - Create schemas] 
database=cnxPostgreSQL1 
input.folder=database/schemas 
multithread=1 
[ExecuteSql - Drop tables] 
database=cnxPostgreSQL1 
input.folder=database/tables-drop 
multithread=1 
[ExecuteSql - Create tables] 
database=cnxPostgreSQL1 
input.folder=database/tables 
multithread=1 
[CSV2DB - Loading1] 
csvQuote=' 
csvSeparator=, 
database=cnxPostgreSQL1 
encoding=UTF-8 
input.folder=datas 
keepDebugFiles=true 
multithread=5 
temp.folder=dataTemp

Sample setting for AS400

The following is an example of ini files used to drop and create tables and view, and loading flat file (EBCDIC) data in POSTGRESQL.

config.ini

[Database - cnxPostgreSQL1]
adminDataBaseName=postgres
adminDataBaseUser=postgres
adminDataBasePassword=postgres
dataBaseHost=localhost
dataBasePort=5432
dataBaseName=cotiviti
dataBaseUser=postgres
dataBasePassword=postgres
stepDatabaseKillDropCreate=false

all.ini

[ExecuteSql - Create tables]
input.folder=database/tables
database=cnxPostgreSQL1
multithread=1

[ExecuteSql - Create views]
database=cnxPostgreSQL1
input.folder=database/views
multithread=1

[EBCDIC2DB - Loading1]
input.folder=data/DataFiles
defaultFixedValues=NOW,NOW,FOLDER,FOLDER
database=cnxPostgreSQL1
multithread=2
csvSeparator=,
csvQuote=‘
ebcdicCodePointShift=384
encoding=CP037
ebcdicNullByteIndicatorPositionMode=ALWAYS_RIGHT
ebcdicOid=false
ebcdicOidLength=0
ebcdicVarcharAsChar=false
ebcdicZonedMode=EBCDIC_STRICT
keepDebugFiles=true
temp.folder=dataTemp
date.format=YYYY-MM-DD
timestamp.format=YYYY-MM-DD HH24:MI:SS.FF
time.format=HH24:MI:SS
error.maxNb=0

[ExecuteSql - Create indexes]
input.folder=database/indexes
database=cnxPostgreSQL1
multithread=5

[ExecuteSql - Execute extra queries]
input.folder=database/extra
database=cnxPostgreSQL1
multithread=1
plainExecution=true