Sawaal
  • Home/
  • Searching for L

 Searching for "L"

Q:

What are the CICS commands available for program control?

Answer

The following commands are available for the Program Control services:


LINK: To pass control to another program at the lower level, expecting to be returned. XCTL: To pass control to another program at the same level, not expecting to be returned.


RETURN:  To return to the next higher-level program or CICS. 


LOAD: To load a program. 


RELEASE: To release a program.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What happens when a CICS command contains the NOHANDLE option?

Answer

- NOHANDLE is an option that can be specified along with abnormal condition during program execution.


- When the exception occurs, no action is performed during execution of NOHANDLE command.


- The abnormal condition is ignored, even the EXEC CICS HANDLE condition exist.


- The abnormal condition is also ignored when EXEC CICS IGNORE condition is tested.


- The previous HANDLE CONDITION for other commands will not be effected with NOHANDLE option.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What CICS command are used to read a VSAM KSDS sequentially in ascending order?

Answer

READNEXT reads the next record from a browse operation for any of the three VSAM files.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

When does the SQL statement gets executed when you use cursor in the application programming?

Answer

SQL statement gets executed when we open cursor


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

Why SELECT * is not preferred in embedded SQL programs?

Answer

- If the table structure is changed ( a field is added ), the program will have to be modified.


- Program might retrieve the columns which it might not use, leading on I/O over head.


- The chance of an index only scan is lost.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is meant by index cardinality?

Answer

The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

How will u send data from a cobol file to db2 table?

Answer

USING HOST VARIABLE we can pass data from COBOL to DB2

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is a DB2 plan?

Answer

An application plan or package is generated by the bind to define an access path. 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview