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

A Table feild is declared as Decimal(7,2). I want to insert
the decimal in to this column thru cobol-db2 program.
How should I declare my local input file variable
or any suggestion?

Answer Posted / nitin

Hello Sumanath and Rajesh

No declaring 9(5)V99 / 9(5)v9(2) comp-3 this way was
not working. I tried this also.

For Example: if the input is 123.45 from flat file
and 1. If I declare 01 W-var pic 9(5)V99
then value of W-var will be 123 45 (It assumed space at
place of decimal) and the same value 123 45 it tried to
moved in the db2 table host varible. which in turn throw
SOC7.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bind package and plan in db2?

1059


What is nvl in db2?

1104


What is a system catalog table in db2?

1192


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1079


What is db2 purescale?

1012


What is the syntax for creating a table in the db2 database?

1110


What does db2 plan contain?

1031


How to find the maximum value in a column in the db2 database?

1085


How is a typical db2 batch pgm executed?

1183


How do I import a csv file into db2?

995


What is runstats utility in db2?

1028


What is db2 stogroup?

1168


How can the duplicate values be eliminated from db2 select?

1107


What is ibm db2 connect?

1005


What is precompiler in db2?

1026