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
how can you check for a records existence without causing and i/o (chain/read)?
Can level check error occur if we do chgpf?
define a output queue?
explain the difference between defining subfile and message-subfile?
define data structure?
what does opcode post do ?
is there any way I can ease my rpg controls on numeric input fields? How about an input date field?
writing an sql statement from selecting records from two files using single statement and nested select statement.
What are the different opcodes used for file operation on a subfile in a rpg pgm?
what are the different methods to access seu?
What Is The Object Type Of Pf, Lf, Printer File & Display File?
what is a logical file?
what is the disadvantage of using global variable?
distinguish between terminating a program through seton lr and return?
what is message file?