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

how do you specify the number of records to roll in a subfile ?

2140


difference between view and index ?

1129


can you specify a display file to be used in the following modes input,output, or combined modes ?

1531


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

1317


how many specifications are there in rpg/400? What are they?

1974


What is the difference between crtdupobj and copyf?

1190


Can level check error occur if we do chgpf?

1240


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

1001


how do you use exceptional write in c specs?

1872


what is term cua , saa?

1593


a multiple format logical file is also known as?

1064


when are the referential constraints executed?

1093


what is the use of jdftval in join logical file?

1780


what is the difference between sflclr and sflinz?

1745


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

2559