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

is it compulsory commitment control in journal?

2083


How do I delete a column in db2?

754


What is a db2 tablespace?

686


What is declare cursor?

703


What is a dbrm in db2?

660






Where do you specify them?

770


What is the difference between nvl and coalesce?

684


What is the difference between cursor and select statement?

714


What is sqlca’s maximum length?

790


What is commit in db2?

687


How do we specify index to include or not during bind process.

1764


What is db2 command?

669


What is the function of logging in the db2 database?

730


Describe major components of db2?

739


How would the varchar column remarks defined?

726