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 to define global parameter in ile ?
What is dynslt?
what is the function of crtdupobj command?
when should I use method get, and when should I use method post in my cgis?
what is a query can be run in which mode?
how to pick up the changed records every time in a subfile after the first change made ?
how to read database records without locking them?
Apart from opening of a file do we have any other use of USROPN?
What is RETURN CURSER LOCATION in subfile?
What is data structure in as400? What is the use of data structure?
is there any way to dynamically merge other html scripts into a given html?
give three main purposes of file specification ?
what if my system I runs with system value qccsid 65535?
If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...
how do u compile rpgle program?