Error message CPF4326 appeared during OPEN for file EMPJ1 (C S D F). .

10 pts.
Tags:
CPF4326
SQL
SQL statements
Hi, I am getting the error below. What is this error...please explain it to me.

Message ID . . . . . . : RNQ1216 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . : 08/18/13 Time sent . . . . . . : 14:11:56 Message . . . . :

Error message CPF4326 appeared during OPEN for file EMPJ1 (C S D F).
Cause . . . . . : RPG procedure JRNP in program JAYSOFT1/JRNP received the message CPF4326 while performing an implicit OPEN operation on file EMPJ1.
The actual file is EMPJ1.
Recovery . . . : Check the job log for a complete description of message CPF4326, and contact the person responsible for program maintenance. If the file has a device type of SPECIAL, there may be no message in the job log.
Possible choices for replying to message . . . . . . . . . . . . . . . :
D -- Obtain RPG formatted printout of system storage.
S -- Obtain printout of system storage.
F -- Obtain full formatted printout of system storage.
More...
Message ID . . . . . . : RNQ1216 Severity . . . . . . . : 99
Message type . . . . . : Inquiry
C -- Cancel.

Answer Wiki

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

Discuss This Question: 4  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
  • philpl1jb

    The system thinks you want to use commitment control, which requires journaling of the files but they aren't journaled.

    Were you intending to use commitment control?

    Is your program RPGSQL

     

    49,550 pointsBadges:
    report
  • TomLiotta

    We can't explain the error because you didn't show us the error. You showed us the message that said that an error happened.

    The error message was CPF4326. You need to show us the error message before we can tell what the problem is. The error has something to do with commitment control, but we can't tell what it is.

    Tom

    125,585 pointsBadges:
    report
  • CharlieBrowne
    If you do not want to use journaling, add COMMIT(*NC) to your SQL statement
    41,370 pointsBadges:
    report
  • TomLiotta
    So far, we don't know if SQL is involved. The error occurred at an "implicit OPEN", so it might be an inappropriate commitment definition over a native I/O operation. -- 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