Interested to Buy Any Domain ? << Click Here >> for more details...
Which command we can use to update a physical file using c.l pgm?
- 19 Answers
- 51602 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 the use of jdftval in as400?
how many specifications are there in rpg/400? What are they?
what are the three line types in rlu ?
which indicator is used for read?
where can you specify an indicator in lokup operation?
What is the difference between crtdupobj and copyf?
distinguish between terminating a program through seton lr and return?
which cl command is used to trap error messages during program execution?
what are the different types of variables available in cl?
What Is The Purpose Of The "n" In The Following Calculation Specification?
the maximum number of subfiles that can defined in a rpg program for one display file is ___ .
during input operation which indicator position is seton if there is a record lock?
how do you read data area in an rpg program?
what is the function of rlu ?
Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?
