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

How to avoid using indicators in ile ?

1217

---

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...

2710

---

which are the string manipulation opcodes?

1030

---

records can be read/update/deleted with which file?

1028

---

what are the two record formats a subfile contain ?

1801

---

what is logical file?

984

---

how can I control the way a remote browser uses its cache?

1111

---

what are the uses of factor1, factor2 and result field for the rpg operation code parm?

984

---

How do you check object lock

779

---

what is a physical file?

1702

---

if we tried to move year part of *iso date into a field of length 3, what will happen ?

1200

---

What is difference between rename and prefix?

991

---

what is scan and xlate?

1735

---

when is a tag statement used in rpg?

2131

---

What are the mandatory keywords of sub file?

1398

---