STRCMTCTL

15 pts.
Tags:
SQL/400
Start Commitment Control
Start Structured Query Language
STRCMTCTL
STRSQL
what is compulsory parameter of STRCMTCTL ?

Answer Wiki

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

My experience has been with RPG and native IO – not SQL

STRCMTCTL LCKLVL(*ALL) CMTSCOPE(*JOB)

1. STRCMTCTL must be issued before files are open
2. Files under native I/O should have a COMMIT on the F spec
3. Files must be journalled to a single journal ??
3. Code should contain one or more COMMIT or ROLLBACK
4. Process should end with ENDCMTCTL

Level check is critical to determine which records are locked — *ALL would be every record that is read by the program.

Discuss This Question: 6  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
  • Sloopy
    If this question is being asked because using SQL is not updating data, and your files are not under commitment control, starting commitment control will not necessarily solve the problem. Instead, add 'with nc' to the end of your SQL statement. This will make SQL process the files without requiring commitment control to be active. Regards, Sloopy
    2,195 pointsBadges:
    report
  • ankit2002
    Why do we use the STRCMTCTL command ,I am confused with this command..
    770 pointsBadges:
    report
  • philpl1jb
    Ankit2002 Please start a new qestion, that way more perts will see it and respond. Please also tell - if you know what commitment control is. Phil
    49,720 pointsBadges:
    report
  • YuVa47
    Phil is correct, but anyway you can learn more from this link YuVa
    1,300 pointsBadges:
    report
  • YuVa47
    which is disappeared but her is now
    report
  • YuVa47
    http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/cl/strcmtct.htm
    1,300 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