What is the COBOL picture clause for a DB2 column defined
as DECIMAL(11,2)?
Answer Posted / pradeep
it is s9(m-n)v9(n) comp-3 in this case m=11, n=2
ie s9(9)v9(2) comp-3
Is This Answer Correct ? | 30 Yes | 4 No |
Post New Answer View All Answers
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Explain in brief how does db2 determine what lock-size to use?
Comment whether the cursor is closed during commit or not.
What is db2 connect?
How do I add a column to an existing table in db2?
Can there be more than one cursor open for any program?
What type of database is db2?
What is drop table?
What is the meaning concurrency in the db2 database?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is cursor stability in db2?
Is db2 a mainframe database?
How do we specify index to include or not during bind process.
What is query_cache_limit?
How can record locking be achieved in those DB2 versions which do not support it?