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 13864

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 16055

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

CTS,

3 13493

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

IBM, TCS, Wipro,

2 18682

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 40464

how many bytes do SPPPP999 will store?

18 23210

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

3 8161

what is partial serch analysys in cics?

2 5457

what is check pending option

Fujitsu,

1 6198

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

4 9060

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

3 9944

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

IBM,

3 31985

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

3 8989

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 16908

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 35455

Un-Answered Questions { MainFrame }

How to restart a DB2 program?

1832

How to get the last record in vsam file in cluster? And how can you get the kids file records into your cobol program?

1146

what are the six different type of argument values in cobol that can be placed in various options of a cics command?

1212

Define cedf?

895

What is dclgen in db2?

1087

What is notcat 2 - gs?

1418

can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.

2735

example for sub strings ? and refernce modifications whit output pls

2271

can we describe the results of opening for input empty vsam files in a cobol program?

953

how do you create an alternate index ?

1023

Define exec cics retrieve?

1117

What is the use of uni-rexx?

880

What is a dbrm in db2?

971

What does db2 mean?

957

Particular area has been affected in cics screen, what is the process to find?

9753

For More Un-Answered { MainFrame } Questions Click Here