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
List down the types of triggers in the db2 database?
How to execute stored procedures?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to resolve deadlock issue
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?
What are the various isolation levels possible?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is clone table?
How many types of page locks can be held in db2?
What is check constraint in db2?
What is runstats and reorg in db2?
Define declaration generator (dclgen).
What is difference between alias and synonym in db2?
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.
Why do we need reorg in db2?