bddname=DB2
driverpath=C:\\Program Files\\IBM\\SQLLIB\\java\\db2jcc.jar
drivername=com.ibm.db2.jcc.DB2Driver
stringconn=jdbc:db2://hostname:port/DATABASE
username=user
password=pass
autoInit=1
selectDatabases=sp_databases
selectTables=list tables for schema SCHEMA
selectFields=select * from SCHEMA.%%table_name%% where 1=2
getSysTables=0
getViews=0
logErrors=0
viewErrors=1
select=SELECT %%fields_names%% FROM %%database_name%%..%%table_name%%
insert=USE %%database_name%% INSERT INTO %%table_name%% (%%fields_names%%) VALUES()
update=USE %%database_name%% UPDATE %%table_name%% SET %%fields_names%% WHERE 1=2
delete=USE %%database_name%% DELETE FROM %%table_name%% WHERE 1=2