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
- 52383 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
how can we run a batch job?
what are different types of substems?
how many types of display are available on as/400 for user interaction?
difference between view and index ?
using dfu, user will be able to ___________ from physical file?
any one have give AS400 study material? pls pass it to gopalsai789@gmail.com
what is *iso date format?
when would you use or not use this approach?
what is meant by object lock requests,held locks and locks waiting to be applied(wrkobjlck) why should we apply for locks.Please explain sir.
how to toggle between single line and multi - line display of a particular record in a subfile?
Difference Between Interactive & Batch Job?
What is diff between EVAL & MOVE?
an access path may be in which sequence?
what does vldcmdkey means?
How Many Specs Are There In Rpg & Which Are They?
