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

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

TCS,

9 14292

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

Amdocs,

10 16395

How we copy a program from production region to development region.What is the process & syntax ?

CTS,

3 13677

Explain complete concept of table handling in COBOL with an example?

IBM, TCS, Wipro,

2 18826

How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog or Ezytrieve and want to do using utility.

Lehman Brothers,

10 40847

how many bytes do SPPPP999 will store?

18 23851

1.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?

3 8314

what is partial serch analysys in cics?

2 5569

what is check pending option

Fujitsu,

1 6297

if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete

4 9282

can we use variable picture clause as xx.99 in cobol.

3 10079

OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes) In which scenario is share(*yes) used? could any one explain with an example?

IBM,

3 32180

Suppose there r total 10 steps. Out of which i want to execute only the 7th step. How can i do that....????

3 9133

Suppose there r 10 steps . Out fo which i want to execute 10th, 9th and 8th in reverse order without using IEBEDIT. How can i do that..???

IBM, UST,

5 17136

How to write a password mask program in as400? like the password which i type should be displayed as '*****' r ###### which the user wishes to dispaly if u could help me with url r the solution in written code this will help me

Accenture, SNS,

21 36283

Un-Answered Questions { MainFrame }

Where can program checkpoints be stored for use in a restart?

1440

what is the difference between normal upddta to pf and updating using dfu program?

1340

What is qsam? How it is used?

743

Explain about maximum displacement?

1059

What is the clustering index in the db2 database?

1001

What are the full forms of spufi and dclgen and why are they used?

1087

can any body give me any website for getting help on mainframe projectts in banking domain.

2106

What are IDMS set of occurances?

1350

what do you mean by recovery and speed parameters in define cluster command?

1109

What is host variable in db2 cobol?

1077

How do you get parameter from JCL to PL1?

2433

What do you understand by the term “keyword” with respect to jcl and what is the opposite of the term?

1143

How do you find whether any generations exist under a gdg base?

1051

what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?

1300

How are data passed from jcl parm to assembler program?

1006

For More Un-Answered { MainFrame } Questions Click Here