OVRDBF in Java

0 pts.
Tags:
Application development
AS/400
CLP
DB2 Universal Database
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?
ASKED: January 22, 2006  11:47 PM
UPDATED: November 25, 2009  2:01 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Make sure that your override is at the same invocation level as your program. I know in CL that makes a difference.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JPLamontre
    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.
    0 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following