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

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1027


What is a db2 table?

990


How can the duplicate values be eliminated from db2 select?

1082


How can we read records for specific member in CL? AND rpg?

681


What is buffer pool and list some of them?

1007


How will you return the number of records in table?

917


What is universal database?

1055


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

1042


Define db2 and its databases?

1040


What is query_cache_limit?

954


What is the syntax for FETCH in DB2 ?

1187


When the like statement is used?

1208


What is dpf in db2?

1089


Can we delete records from view?

953


What is null in db2?

999