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

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4372


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3204


How and when does the db2 enforces the unique key?

1143


Why do chiropractors use drop table?

1164


Explain various types of locks in db2?

1204


Which command is used to remove all rows from a table?

1180


Define predicate?

1202


How to check sequence on a table in db2?

1116


What are the different types of base tables?

1163


What are iseries servers?

1132


How to test SQL -911 error while developing COB-DB2 program

7670


Mention the downsides of page level lock.

1214


what are bind concepts in db2 cobol?

1137


Mention some fields that are a part of sqlca.

1096


How to resolve deadlock issue

20318