Set pjarid = Nothing
Set pclassid = Nothing
Set pjarurl = Nothing
Set prc = Nothing
This worked for me executed from a VBA module in MS Access on a Win2k machine.
The DB2 instance version is DB2/6000 8.1.5.
The jarid was
The classid was
The source PROCTEST.java file was located on the db2 host filesystem at
The sub was executed from the client system with
Though as yet untested, I assume this would work just as well similarly called from C/C++, java, etc. Pure speculation is there is an imcompatibility somewhere in the CLP interface that is bypassed when sqlj.updatejarinfo is called via the OLE/DB interface instead.
Let me know if you adapt it to java or something else I might be able to
execute from command-line - I'll probably try java next myself, otherwise
compile a quick .exe from the VB.