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

how can you check for a records existence without causing and i/o (chain/read)?

2062


Can level check error occur if we do chgpf?

1239


define a output queue?

1562


explain the difference between defining subfile and message-subfile?

1841


define data structure?

1726


what does opcode post do ?

1750


is there any way I can ease my rpg controls on numeric input fields? How about an input date field?

1099


writing an sql statement from selecting records from two files using single statement and nested select statement.

1168


What are the different opcodes used for file operation on a subfile in a rpg pgm?

1804


what are the different methods to access seu?

1079


What Is The Object Type Of Pf, Lf, Printer File & Display File?

1148


what is a logical file?

1774


what is the disadvantage of using global variable?

1190


distinguish between terminating a program through seton lr and return?

1074


what is message file?

1035