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 / rajeev

We can not update a database file throught CL in a normal
way but if we use QSH then we can update or insert. Here I
am showing a exaple of insert.

QSH CMD('db2 "insert into $SCHEMA.$TABLE + VALUES(12,
5,''rajeev'', ''2009-11-24'',.2" ')

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

which are the figurative constants used in rpg?

1326


the maximum number of subfiles that can defined in a rpg program for one display file is ___ .

3275


define a shared access path?

1751


what is the purpose of putovr (put with explicit override) keyword?

1646


define the purpose/use for sflrna?

1645


how to validate input values in display file ?

1220


what is the difference between seton lr and retrn?

2038


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

1462


what is the difference between normal upddta to pf and updating using dfu program?

1338


What is data structure in as400? What is the use of data structure?

1083


What is access path in as400?

1347


What is difference between rename and prefix?

1034


What is array in as400? What are the types of array?

1111


which are the relational operators in rpg?

1120


what are the various types of device files?

1677