PIC S9(9)V99 COMP-3. In DECIMAl(11,2), 11 indicates the size of data typ

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

Question Posted / srinivasa gudla

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

Please Help Members By Posting Answers For Below Questions

Mention the different locking levels that are available in db2.

1070

What is coalesce in db2?

1055

What are db2 tables?

1050

What is check constraint. Explain with example.

1044

What is the result of open cursor statement?

1028

What is role in db2?

1040

What is an instance database?

1005

Explain the function done by data manager?

1216

What is a db2 tablespace?

999

Can you tell me how can you find out the # of rows updated after an update statement?

1044

What is difference between isnull and coalesce?

1007

Mention the location where the output received from explain statement is stored.

1054

What is buffer pool in the db2 database?

1046

How to compare data between two tables in db2?

1032

How do I create a view in db2?

973