1. Categories >> Software >> MainFrame
  2. Suggest New Category


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 11346

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 13560

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

CTS,

3 12214

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

IBM, TCS, Wipro,

2 17628

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 37539

how many bytes do SPPPP999 will store?

 18 18168

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

3 7000

what is partial serch analysys in cics?

 2 4698

what is check pending option

Fujitsu,

1 5323

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

 4 7659

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

 3 8803

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

IBM,

3 30328

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

 3 7767

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 15208

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 30176

Un-Answered Questions { MainFrame }

why is the declare cursor statement is used for?

632

do you use message subfiles? What are the necessary keywords required coding a message subfile?

692

define cond parameter in jcl?

779

explain the use of dftwrt display keyword?

1139

Explain difference between escape(top or bottom) and escape immediate(top or bottom?

629




How to get the last record in vsam file in cluster? And how can u get the ksds file records into cobol program?

585

Why do chiropractors use drop table?

663

List out the data types available.

704

What is static and dynamic call in cobol?

597

Highlight all the advantages that are attached to a package.

629

how can you prevent more than one user from accessing the same transient data queue?

610

What is adabas and why it is used?

564

What is defragmentation and what is its advantage?

548

What is downtime and what might be the reason?

555

How to find the number of rows in db2 tables?

617

For More Un-Answered { MainFrame } Questions Click Here