What are the COBOL host variable equivalent for various DB2 data types?

The host variables are used to transfer the data from DB2 to program and vice versa.For each DB2 table column we have a COBOL equivalent host variable defined. The host variables can be generated automatically using the DCLGEN utility or we can explicitly give the host variables in the working storage section of the COBOL-DB2 program.

The COBOL equivalent of various DB2 data types is mentioned in the table below.

Mandalika

Published on 14-Sep-2020 14:27:03

• Related Questions & Answers
• What is COBOL host variable equivalent for various DB2 data types?
• What are the default values used by DB2 for various data types?
• Convert DECIMAL(7,3) into equivalent COBOL host variable PIC form.
• What are COBOL equivalents of DB2 data types SMALLINT, INTEGER and DECIMAL?
• What are COBOL equivalents of DB2 data types CHAR, DATE, TIME and TIMESTAMP?
• What are various Text data types in Python pandas?
• What are the various types of branches?
• What are the various tools for Data Warehouse Quality?
• What is the usage and purpose of DCLGEN and host variables used in COBOL-DB2 program
• What are the various types of comments in JavaScript?
• How to truncate trapping of a DB2 column data when assigned to a host variable
• How will the COBOL-DB2 program behave when there is a mismatch between the host variable and number of columns in the SELECT statement?
• What are the various issues related to data mining?
• What are the various extraction methods in data warehouses?
• What are the steps involved to use a CURSOR in any COBOL-DB2 program?