MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31)

MainFrame Interview Questions

Questions Answers Views Company eMail

Hi Folks, In the Map, one field is having attribute FSET. I want to FSET OFF of that field through program. Can any body let me know the process? Thanks Praveen

3 8337

What is quasi rentrancy concept in CICS?

HCL,

1 7816

If -1 is moved to length for more than one field on a map, where will the cursor be positioned?

6 9859

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 9283

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 5094

Q1. How to use signature in service program and ILE.? Q2.what is use of signature and binder language and what is the relation between them?

CTS,

2 33754

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 8703

What is the difference between Primary key and unique index?

6 10277

My JCL have five steps & I created new versions of GDG in first step through fourth step & fifth step I was refered Step one GDG version. My JCL got abend at 4th step and how I can restart my JCL Please let me know the answers. //STEP1 EXEC GDG1(+1) DISP=(NEW) //STEP2 EXEC GDG1(+2) DISP=(NEW) //STEP3 EXEC GDG1(+3) DISP=(NEW) //STEP4 EXEC GDG1(+4) DISP=(NEW) //STEP5 EXEC GDG1(+1) DISP=(OLD)

HCL, IBM, L&T, TCS,

11 57525

How many types of parameters are used in JCL and what are mandatory parameters of JOB statement.

IBM,

13 27622

What is the use of a COPYBOOK in Fileaid ?

Steria,

4 11870

Looking for mainframes IMS DB training @ 9912598882

3 7295

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 9041

What is package versioning? Please give an example.

1 4802

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 6355

Un-Answered Questions { MainFrame }

Please send me the real time scenarios in Mainframe Project... i.e., it may be in banking or insurance sector or any other no problem..... please send your mails to krishnaprasadbvs@gmail.com

11750

Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?

1227

explain in brief what are the 3 types of vsam files?

1109

How do we pass parameters into a CICS –DB2 program

4157

how does union file maintains record formats?

1104

What is an ook-rec in idms?

872

what is the necessary keyword needed to scroll subfile records?

1161

Can you explain dfhmdf bms macro?

1061

Is condition checking possible in jcl?

1215

How jcl work to handle various input output file operations?

1169

Explain the difference between the xctl and link commands?

1116

How to read and write a single record into a file. I would like to use it to enter a single 8-character piece of information and use it to put it into a variable for processing in JCL. Thank you

1076

What is the use of qsam?

826

what is “Cond= even” and “Cond=only”?

1313

Explain the difference between a physical bms mapset and a logical bms mapset?

999

For More Un-Answered { MainFrame } Questions Click Here