Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 data structure in as400? What is the use of data structure?

1079


what are all the contents of subfile?

1690


what are the various types of device files?

1673


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

1200


Difference between NOPASS & OMIT?

1845


what is maximum number of arrays allowed in rpg?

1906


How to avoid using indicators in ile ?

1267


what are dds required for subfile?

1037


which are the member types which seu supports?

1326


What is %CHECK?

1268


what is the maximum number of record formats in dspf?

1680


what does dfu program you to do on a record?

1218


what is the maximum number of files allowed in rpg?

1637


how to run other job when one job is active?

1014


What are the mandatory keywords of sub file?

1463