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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I change the column size in db2?

583


When the like statement is used?

627


What are types of indexes?

585


Mention some fields that are a part of sqlca.

593


Is the primary key a clustered index?

602






Explain various types of locks in db2?

682


What is explain plan in db2?

583


Can there be more than one cursor open for any program?

652


Define buffer pool.

617


Can one database have multiple instances?

578


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1887


What is the maximum No of rows per page?

622


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

598


What is deadlock in db2?

572


What is difference between rollback and commit?

616