Skip to content

Instantly share code, notes, and snippets.

@tepie
Created November 15, 2012 14:28
Show Gist options
  • Save tepie/4078880 to your computer and use it in GitHub Desktop.
Save tepie/4078880 to your computer and use it in GitHub Desktop.
db2 load over jdbc with CALL SYSPROC.ADMIN_CMD
<sql driver="${DB.DB2.DRIVER}" url="${DB.DB2.JDBC.URL}" userid="${DB.DB2.USER}" password="${DB.DB2.PASSWORD}">
<classpath>
<pathelement location="${DB.DB2.CLASSPATH}"/>
</classpath><![CDATA[
CALL SYSPROC.ADMIN_CMD('
load from ${remote.directory.put.to}/${LOCAL.FILE.LOGAN.PARSED} of del modified by coldel| method P(..... ) insert into ${DB.DB2.SCHEMA}.${DB.DB2.TABLE} (....) nonrecoverable
');
]]></sql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment