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...

How to define the a field which accepts value till 99999.99
in db2

Answer Posted / ram prajapati

in db2 decimal(7,2) & application cobol pgm 9(5).99
because 9(5)v99 will print 9999999 and not 99999.99.
9(5).99 is an edited pic variable so it will show the
desired output while the previous one will not.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the reason behind not using select * in embedded sql programs?

1047


What is bind package and plan in db2?

1006


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1312


What is collection in db2 bind?

964


What is a collection in db2?

986


How to take backup of table in db2?

1023


How and when does the db2 enforces the unique key?

1032


What is universal database?

1029


Outputs of explain are with matchcols = 0. What does this signify?

992


What is ibm db2 client?

882


How can you find out the # of rows updated after an update statement?

1053


Define db2 and its databases?

1006


How to check sequence on a table in db2?

997


Can we delete records from view?

916


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2868