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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the usage of open cursor command?

599


How many types of page locks can be held in db2?

589


What is db2 connect?

599


Explain what are the various isolation levels possible?

606


How would the varchar column remarks defined?

631






How to view db2 table structure?

585


What are union and union all?

537


Which components manage deadlocks in db2?

604


What are the contents of a dclmgen?

628


define clustering index.

614


What is a trigger in the db2 database?

592


What is reorg?

617


What is nvl in db2?

624


What is view db2?

622


How will you return the number of records in table?

514