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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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?

Question Posted / nitin

Answers were Sorted based on User's Feedback



A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cob..

Answer / rajesh

u can declare in application program(cobol)
01 dec pic 9(5)v9(2) comp-3. is equal to dec(7,2)

Is This Answer Correct ?    16 Yes 4 No

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cob..

Answer / prabhakar

u can declare in application program(cobol)
01 dec pic 9(5).9(2). is equal to dec(7,2)

Is This Answer Correct ?    11 Yes 5 No

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cob..

Answer / sumanth toom

hmmm..depends how you want to use that variable.
9(5).99 is an edited field. Probably used for printing or
reporting purposes.

Otherewise, 9(5)V99 can be used.

Is This Answer Correct ?    5 Yes 1 No

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cob..

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

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cob..

Answer / nitin

Thanks... Prabhakar
This works

Is This Answer Correct ?    2 Yes 2 No

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cob..

Answer / baalu

hello, nitin...
try this one s9(7-2)v9(2)comp-3
this is similor to s9(x-y)v9(y) comp-3



with best regards,
baalu.

Is This Answer Correct ?    1 Yes 1 No

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cob..

Answer / mf_nerd

PIC S9(5)V99 COMP-3.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB2 Interview Questions

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  

What does DML stand for and what are some examples of it?

3 Answers   IBM,

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

What are the different types of base tables?

0 Answers  

Update command

1 Answers  

Can we update view in db2?

0 Answers  

What is view db2?

0 Answers  

What is release/acquire in bind?

0 Answers  

On which levels locks can be applied?

0 Answers  

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  

What is database manager in db2?

0 Answers  

For more DB2 Interview Questions Click Here
Categories