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

PIC S9(5)V99 COMP-3.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List down the types of triggers in the db2 database?

581


How to execute stored procedures?

614


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

700


How to resolve deadlock issue

17926


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2042






What are the various isolation levels possible?

642


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

692


What is clone table?

587


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

585


What is check constraint in db2?

597


What is runstats and reorg in db2?

787


Define declaration generator (dclgen).

660


What is difference between alias and synonym in db2?

635


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2748


Why do we need reorg in db2?

555