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?
- 7 Answers
- 19149 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Explain the EXPLAIN statement?
How Plan is created while executing the query using SPUFI?
Which components manage deadlocks in db2?
What is index in db2?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
Mention data types used in db2 ?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What does an outer join do?
What is the syntax for creating a table in the db2 database?
what is difference between Static call and Dynamic call? How does it function?
How to fetch the uncommited data from table ?
how we will do null data selection in cobol-db2 program
COBOL 
