- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
| DB2 data types | COBOL equivalent |
|---|---|
| SMALLINT - 2 bytes | PIC S9(4) COMP |
| INTEGER - 4 bytes | PIC S9(9) COMP |
| TIMESTAMP - 10 bytes | PIC X(26) |
| CHAR - 5 bytes | PIC X(5) |
Updated on 14-Sep-2020 14:28:07
- 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 the various techniques for data extraction?
- What are various Text data types in Python pandas?
- What are the various types of branches?
- What are the various types of contracts?
- 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?
Advertisements