MainFrame Interview Questions
Questions Answers Views Company eMail

What is the difference between base table and view?

7 30276

I have a KSDS File.I hav a Records like 1,2,3,4,5,6,...100. I want to read using Dynamic mode like from 10 th Record onwards like, 10,12,14,16,18,....60. Waht is the command for this.

CTS,

2 7364

what is the difference between adding keys & constraints into a phisical file

HSBC,

4 9587

what is the difference between adding keys & constraints into a phisical file

HSBC,

6 13112

How we can't update join logical files?

10 21816

what is the purpose of DMPCLPGM IN CL?

IBM, Wipro,

3 17167

How can i write a comp-3 variable into a sequential file should i declara the field in the file description as comp- 3?

1 9934

I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?

Mind Tree, TCS,

9 21762

what is QSAM?use of the QSAM?how it is used?

1 6186

Alt key is used for what type of vsam file

3 6368

How many cluster index can have in a table?

HSBC,

3 6259

what is level 66 means??

7 25623

What is UNION,UNION ALL?

2 12339

What are the different types of VSAM files available?

CSC,

3 11419

What is Control Interval, Control Area ?

L&T,

1 6487


Un-Answered Questions { MainFrame }

Which component is responsible for processing sql statements and selecting access paths?

661


Explain the different system tables used in cics?

536


can I touch the array during treatments?

750


What is drda ?

595


what is the sequence when using cursor?

603






How to restart a DB2 program?

1356


What is table space in db2?

575


Discuss record management in vsam?

543


When an area sweep is used?

444


What is copy pending status in db2?

634


how does the runqry show the output?

879


Explain foreign keys?

551


What is a db2 table?

593


how you will find an error which is not in the first page of the subfile without using rolldown key?

551


what are the secirity tools in mainframe? and let me know about the other tools and the uses of thst immediatly................

2000