Which command we can use to update a physical file using c.l pgm?
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 are the different types of arrays available in rpg ?
how can I control the way a remote browser uses its cache?
explain the use of dftwrt display keyword?
what are the different commands used in rlu ?
What is array in as400? What are the types of array?
how can database records be read without lock ?
what are dds required for subfile?
what is the maximum number of records you can specify in a display file?
is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?
Explain The Keywords Edtcde & Edtwrd?
How Many Specs Are There In Rpg & Which Are They?
what is externally described file ?
how many printer files maximum can be used in single rpg program?
what is *iso date format?
can we use ASCII ,CDUP,SENDPASV commands in SFTP?