Which command we can use to update a physical file using c.l pgm?
- 19 Answers
- 46194 Views
- Ocwen, I also Faced
- E-Mail Answers
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
is it there an easy way to determine if an html section is available to issue a wrtsection upon?
Apart from opening of a file do we have any other use of USROPN?
is it possible to create a physical file without dds?
maximum number of subfiles that can defined in a rpg program for one display file is?
Service Program : S1 Modules in S1 : M1 M1 having two procedures : ADD, SUB Current Binder Language STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP Doubt: I need to add one new Module to the Service Program M2 having one procedure ‘MULT’ How to add this new module to the service program S1 ? If I need to recreate the service program again, Do I need to mention the Module M1 again while recreating along with new Module M2? There is no Binding Directory. Binder language structure will be like this STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") EXPORT SYMBOL("MULT") ENDPGMEXP STRPGMEXP PGMLVL(*PREVIOUS) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP
how you get the relative record in a subfile in which cursor is located?
how to run other job when one job is active?
what is rpg fixed logic cycle?
what is the maximum number of record formats in dspf?
if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?
how can I control from my cgis the cache of a remote browser?
how you will find an error which is not in the first page of the subfile without using rolldown key?
Can any one explain the basic things about RLU and Printer Files and their Definitions for both and why are they used,i'm a newbee so please help me out
What is %CHECK?
what is the clp command to access a query/400?
