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

Answers were Sorted based on User's Feedback



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

Answer / kk

in db2 decimal(7,2) & application cobol pgm 9(5)v99.

Is This Answer Correct ?    33 Yes 1 No

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

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

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

Answer / keshireddy

PIC S9(5)V99

Is This Answer Correct ?    2 Yes 19 No

Post New Answer

More DB2 Interview Questions

What is Reorg Recovery? when will you run it?

2 Answers  


How does cobol compile db2 program?

0 Answers  


What is a lock?

1 Answers  


How do you stop a db2 database in linux?

0 Answers  


Update command

1 Answers  


I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  


Explain transactions, commits and rollbacks in DB2.

3 Answers  


What Utility is used to migrate DB2 from one release to the next?

1 Answers  


What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


What does a deadlock mean in DB2?

0 Answers  


What does db2 plan contain?

0 Answers  


What is a buffer pool?

2 Answers  


Categories