Which command we can use to update a physical file using c.l pgm?
- 19 Answers
- 46247 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
what is rpg ?
which are the query selection criteria, which can be given in a query?
if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?
how to get the cursor position?
when do you explicitly open files and close files in an rpg program?
how many types of display are available on as/400 for user interaction?
what keyword must be used with protect keyword ?
why is as/400 called object oriented machine?
what is sflrolval?
what is externally described file ?
define data structure?
what are dds required for subfile?
what is the length of a variable in rpg?
what are the uses of factor1, factor2 and result field for the rpg operation code parm?
what is the purpose of overrides?
