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
- 18926 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 about rct.
What is lock contention?
What are the various isolation levels possible?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
How many clustering indexes can be defined for a table?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
What is meant by AUTO COMMIT?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How do I import data from excel to db2?
What is dbrm library?
What is with ur in db2?
How many buffer pools are available in db2?
COBOL 
