Home > IT Answers > Development > STRCMTCTL
Aum
15 pts.
 STRCMTCTL
SQL/400, Start Commitment Control, Start Structured Query Language, STRCMTCTL, STRSQL
what is compulsory parameter of STRCMTCTL ?

Software/Hardware used:
ASKED: November 18, 2008  10:42 AM
UPDATED: July 12, 2011  6:24 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  November 18, 2008  2:27 pm  by  philpl1jb   44,630 pts.
All Answer Wiki Contributors:  philpl1jb   44,630 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Sloopy
 2,195 pts.
 

Why do we use the STRCMTCTL command ,I am confused with this command..

ankit2002
 670 pts.
 

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

philpl1jb
 44,630 pts.
 

Phil is correct, but anyway you can learn more from this link

YuVa

YuVa47
 1,285 pts.
 

which is disappeared but her is now

YuVa47
 1,285 pts.
 
YuVa47
 1,285 pts.