OVRDBF in Java
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 22, 2006 11:47 PM
UPDATED:
November 25, 2009 2:01 AM
Answer Wiki:
Make sure that your override is at the same invocation level as your program. I know in CL that makes a difference.
To see all answers submitted to the Answer Wiki: View Answer History.
are you sure your ovrdbf is valid after leaving the qcmdexc ? due to program imbrication level, it can be rolled back.
Notice tha SQL order for cld ovrdbf is ALIAS. I suggest creating an alias in qtemp, if possible. I never have run sql with JDBC.
An ALIAS might be a good idea, but be aware that it creates a permanent (SQL) object. An OVRDBF might be needed, especially if the member name is variable. If creating SQL objects is not allowed, then OVRDBF is required.
For the original question, exactly how was QCMDEXC invoked? It would need to be invoked as a stored proc if it was going to work at all. And what does the OVRDBF look like? Some parms might need changing.
Tom