Which command we can use to update a physical file using c.l pgm?
Answer Posted / anupam
Use of RUNSQLSTM helps in updating the physical file within
a CL program.
Syntax:
RUNSQLSTM SRCFILE(LIB/QSRCPF)SRCMBR(SQLPGM)COMMIT(*NONE)
SQLPGM should contain
UPDATE PF set DATA='Value' where DATA'='Value1' and it will
update the PF
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is data structure in as400? What is the use of data structure?
what are all the contents of subfile?
what are the various types of device files?
how can I control the way a remote browser uses its cache?
Difference between NOPASS & OMIT?
what is maximum number of arrays allowed in rpg?
How to avoid using indicators in ile ?
what are dds required for subfile?
which are the member types which seu supports?
What is %CHECK?
what is the maximum number of record formats in dspf?
what does dfu program you to do on a record?
what is the maximum number of files allowed in rpg?
how to run other job when one job is active?
What are the mandatory keywords of sub file?