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

define the purpose of the leave operation?

1694


which are the string manipulation opcodes?

1123


different type of cursor?

1102


how do you know that records are locked?

2035


Write a CL program which will run a batch job at 1 am every night

1142


how will you display a particular page in subfile ?

1760


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

1950


how to get the cursor position?

1192


What is binder language ?

1968


What is file information data structure(infds) in as400?

1527


what is rpg ?

1738


what do we can do with the embedded sql statements?

1111


what is match field indicator?

1823


What is compiler directive in as400? Give example of compiler directive.?

1167


what is the favicon.ico request that my site receives now and then?

1159