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 the default access path of a file?
what is the function of crtdupobj command?
all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?
define what a data queue is along with a brief example of what it may be used for?
which are the relational operators in rpg?
how do you know that records are locked?
how many printer files can be defined in f specs ?
how do you specify the number of records to roll in a subfile ?
how to declare a constant variable in the freeformat?
What is the as400 called now?
what is the maximum number of fields under a record format of physical file?
how may a cgi control duplicate inputs?
what is scan and xlate?
what is the version of os/400 that we have?
when should I use method get, and when should I use method post in my cgis?