<?xml version="1.0"?>

<!DOCTYPE serverType SYSTEM "sqlServerType.dtd">

<serverType name="DB2Local">

  <driverClass>COM.ibm.db2.jdbc.app.DB2Driver</driverClass>

  <!--<vfs>sql.serverTypes.OracleVFS</vfs>-->

  <connection>
    <parameter name="database" default="sample" description="Database to connect to"/>
    <parameter name="user" default="scott" description="DB2 user"/>
    <parameter name="password" default="tiger" description="DB2 password"/>
    <string>jdbc:db2:{database}</string>
  </connection>

  <statements>
    <statement purpose="selectTableGroups">
      SELECT DISTINCT tabschema AS tabschema
      FROM syscat.tables
    </statement>
    <statement purpose="selectTablesInGroup">
      SELECT tabname AS tabName
      FROM syscat.tables
      WHERE tabschema = ?
    </statement>
  </statements>

</serverType>