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


Please Help Members By Posting Answers For Below Questions

what is the syntax for plist?

625


what is the use of sflend keyword?

949


what is the maximum number of records you can specify in a display file?

1077


is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.

2099


what is rpg fixed logic cycle?

635






how do you use commitment control in rpg program ?

1240


If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?

1456


what is the disadvantage of using global variable?

655


what are members?

590


how to define to define a hidden filed in dspf ?

747


under given circumstances, my cgi should link to another site. How to implement this?

547


Which command is used to replace CDUP command in FTP IF i WANT TO USE SFTP?

1744


what is the difference between udate and the system date?

1117


Why we are not able to perform insert delete and update operation in Join logical file?

905


in conjunction with which statements can orxx and andxx conditions be used ?

1097