What is the COBOL picture clause for a DB2 column defined
as DECIMAL(11,2)?

Answers were Sorted based on User's Feedback



What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?..

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

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?..

Answer / ranjana

its s9(9)v99.

Is This Answer Correct ?    24 Yes 7 No

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?..

Answer / guest

its s9(9)v99.

Is This Answer Correct ?    11 Yes 8 No

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?..

Answer / srinivasa gudla

PIC S9(9)V99 COMP-3.

In DECIMAl(11,2), 11 indicates the size of data type and 2
indicates the precision.

Is This Answer Correct ?    1 Yes 0 No

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?..

Answer / sudhanshu

S(9)V9(2) USAGE COMP-3

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More DB2 Interview Questions

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  


When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,


What are the uses of db2 optimizer?

0 Answers  


what are the max. & min. no. of partitions allowed in a partition tablespace?

1 Answers   IBM,


How to handle null values in db2

4 Answers  






Is the primary key a clustered index?

0 Answers  


What is an instance database?

0 Answers  


What's The Percentage Free Space ?

0 Answers   IBM,


What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,


Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,


what's the error code for Unique Index Violation?

2 Answers  


What is a root page?

1 Answers  


Categories