Which command we can use to update a physical file using c.l pgm?
- 19 Answers
- 46085 Views
- Ocwen, I also Faced
- E-Mail Answers
Answer Posted / sumit
Everyone is saying we cannot update pf using Cl...But please
try once using RUNSQLSTM before marking 'NO' to any answers.
As we can update a PF using CL.
RUNSQLSTM uses source file where source member is present.
And this source member contain UPDATE SQL, OR DELETE SQL, OR
INSERT SQL.
RUNSQLSTM SRCFILE(LIB/QSRCPF)SRCMBR(SQLPGM)COMMIT(*NONE)
Once this statement run in CL then PF will get updated,
deleted or inserted with the new record.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?
what does opcode post do ?
in which specification the report layout can be defined?
what is a logical file?
Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?
can you specify a display file to be used in the following modes input,output, or combined modes ?
in conjunction with what other keyword must ovrdta and ovrata be used?
which are the query selection criteria, which can be given in a query?
define the purpose of the iter operation?
can a join logical file be updated?
What Is The Purpose Of The "n" In The Following Calculation Specification?
what is a primary file?
what are the different opcodes available in rpg for database access ?
which cl command can be used at program execution to redirect the file named in an rpg program?
What is binder language ?
