Which command we can use to update a physical file using c.l pgm?
- 19 Answers
- 49135 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
Apart from opening of a file do we have any other use of USROPN?
what keyword must be used with protect keyword ?
what is the command used to invoke rlu ?
what is the use of dspatr(mdt) keyword?
what do we can do with the embedded sql statements?
what would be the effect on the field where reverse image, underline and highlight display attributes are active ?
what is the function of rlu ?
what is a program described file in rpg?
what is a primary file?
explain the difference between defining subfile and message-subfile?
how to read database records without locking them?
Which command is used to replace CDUP command in FTP IF i WANT TO USE SFTP?
Can we debug the MSGW JOBS?
how do handle file exception/error?
when do you use f-spec. Continuation line ?
