Created
November 15, 2012 14:28
-
-
Save tepie/4078880 to your computer and use it in GitHub Desktop.
db2 load over jdbc with CALL SYSPROC.ADMIN_CMD
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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