Latest Cobol And DB2 Interview Questions Part – 3

When You Will Face Sqlcode -911?

At the time of deadlock or timeout you will face SQLCODE -911.

When You Will Face Sqlcode -922?

If a user is not authorized to access DB2 objects, he will face SQLCODE -922.

When You Will Face Sqlcode -818?

SQLCODE -818 is a timestamp mismatch of load module and bind timestamp built from DBRM.

In A Cobol-db2 Program Where Can We Declare A Cursor?

We can declare a cursor either i Working Storage Section or in Procedure Division also.

Suppose We Added A New Column By Using Alter Statement, Where The Column Will Be Added?

When we use ALTER statement for adding a new column then it will be added at the end of the table.

How You Will Count The Number Of Rows From A Table Tab?

SELECT COUNT(*) FROM TAB query is used to count the number of rows in a table.

What Are The Different Types Of Vsam Datasets?

Entry sequenced datasets (ESDS), Key sequenced datasets (KSDS), Relative record dataset (RRDS) and Linear dataset (LDS).

What Is A Control Interval?

A control interval is the unit of information that VSAM transfers between virtual and auxiliary storage.

How Are Records Stored In An Esds?

Records are stored in the order in which they are included in the file.

What Is A Control Area?

A group of control intervals makes up a control area.

What Is A Cluster?

A cluster is the combination of the index, sequence set and data portions of the dataset. The operating system gives program access to the cluster, that is to all parts of the dataset simultaneously.

What Is The Catalog?

The catalog contains the names of all datasets, VSAM and non-VSAM. It is used to access these datasets.

What Is An Alternate Index?

An alternate index is a file that allows access to a VSAM dataset by a key other than the primary one.What Is A Path?
A path is a file that allows you to access a file by alternate index. The path provides an association between the AIX and the base cluster.

What Is Free Space?

Free space is reserved within the data component of a KSDS to accommodate insertion of new records.