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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sqlca?

632


What are types of indexes?

603


what is the sqlcode -501

11338


Explain db2.

630


How do we specify index to include or not during bind process.

1682






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

638


Mention some fields that are a part of sqlca.

610


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

734


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7548


How does cobol compile db2 program?

617


What are the contents of dclgen?

665


What is role in db2?

629


Can there be more than one cursor open for any program?

669


What are foreign keys in db2?

626


How do I connect my db2 database to ibm?

611