For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

Answers were Sorted based on User's Feedback



For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause...

Answer / santhoshabbula

PIC S9(9).99

Is This Answer Correct ?    0 Yes 0 No

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause...

Answer / Rajan Kumar Gupta

In COBOL, the picture clause for a DB2 column defined as decimal(11, 2) would look like this: 01 column-name PIC S9(11)V9(2). Here, S9(11) indicates that the field can hold up to 11 digits (including spaces), and V9(2) specifies that the field should be right-justified and display 2 decimal places.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB2 Interview Questions

What is a cursor in programming?

1 Answers  


Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  


What happens to the PLAN if index used by it is dropped?

1 Answers  


can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  


What information is used as input to the bind process?

2 Answers  


what are stage one indexable predicates?

1 Answers  


What is rebind in db2?

1 Answers  


What is meant by explain?

1 Answers  


What are the various locks available?

5 Answers   CTS,


Define predicate?

1 Answers  


What is a page in db2?

1 Answers  


Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  


Categories