GeekInterview.com
Series: Subject:

Mainframe FAQs

Showing Questions 1 - 20 of 105 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

How to turn off mouse?

Asked By: Utsav Kumar | Asked On: Dec 18th, 2012

Hello geeks, actually I download a lot of torrents and that means my desktop is on most of the times. So for power saving purposes I do switch off my monitor using hotkeys. Recently I was thinking that maybe I can turn off my mouse too which may save a little more power. (if anything can be saved, it...

What is the difference between plan & packagewhat is difference between views & joinswhat is db2 stored procedures? How to work it in mainframehow to calculate n th maximum valueif the error code -811...

Asked By: latha | Asked On: Aug 22nd, 2007

Answered by: mannurusrinivasulareddy on: Sep 1st, 2012

1. Plan is executable,Pakage is non-executable and Plan contains packages. n No. of pgms contains n No. of packages but only one plan. 2. View is Just a logical table to Base tables for ex: if we are...

Answered by: viji.mumbai on: Oct 3rd, 2007

Hi Latha,I could suggest you to refer DB2-SQL Red books And online help while working with mainframe.Anyhow, I will answer to few of your questions.Plan is executable code and it contains access path ...

Passing data dynamically

Asked By: sprabodhini | Asked On: May 21st, 2008

How data can be passed to a dynamically called module without using linkage section?

Answered by: ahobalanag on: Aug 25th, 2012

Here are some of the methods I can think of:- 1. Write the data you want to pass from the called program to a temp file. In the called program, read the temp file and get the data. 2. You can use MQs ...

Run a job

Asked By: prabhakar.shanmugam | Asked On: Jul 22nd, 2008

How to run a job without using ispf?

Answered by: ahobalanag on: Aug 25th, 2012

At the TSO "READY" prompt, type SUB . Once you hit enter your job will be submitted. To monitor the job, at the TSO prompt, type SDSF. SPOOL opens up and you can monitor your job.

Answered by: vjjammi on: Feb 18th, 2009

Without submitting the job through the ISPF Facility, we could schedule the same job through CA-7 schedular which makes the job run automatically at the provided schedule. 

Creating dclgen

Asked By: sandyko07 | Asked On: Feb 11th, 2009

How to create a dclgen using tso? How do we include it in cobol-db2 program?

Answered by: ahobalanag on: Aug 25th, 2012

You can run a job like this:-
//DCLGEN EXEC PGM=IKJEFT1B
//SYSTSIN DD *
DSN SYSTEM()
DCLGEN TABLE() +
LIBRARY ()) +
ACTION(ADD) APOST +
LANGUAGE(IBMCOB)
END

You will have to allocate other appropriate libraries before running this JCL.

To include the DCLGEN in your COBOL program, you can say:-

EXEC SQL
INCLUDE
END-EXEC.

Make sure you have the library where you created this DCLGEN concatenated to DDNAME SYSLIB on your precompile job.

Job card parameters

Asked By: shamsheer505 | Asked On: Sep 23rd, 2010

What are the mandatory parameters in the job card?

Answered by: chaithanya on: Aug 7th, 2012

In jobcard jobname is mandatory, class and msgclass parameters also mandatory

Answered by: tag_tushar on: Sep 24th, 2010

The only mandatory field in a job card parameter is the jobname the rest of the parameter are installation defined...Ex://JOBNAME JOB //STEP EXEC PGM=IEFBR14//DD1 DD DSN=USERID.ABC.XYZ,DISP=(NEW,...

Filtering 2 files

Asked By: Krishnapreetham | Asked On: Jun 26th, 2008

How to filter 2 different files with one common field and write records from one of the files to an output file?

Answered by: Shyam on: Jun 18th, 2012

By using Joins...

A join operation on 2 tables combines the rows from one table with those of the other, join the 2 tables based on common columns.

Status code

Asked By: shikhakalia06 | Asked On: Jun 1st, 2009

What will be the status code of open empty vsam file?

Answered by: Shyam on: Jun 18th, 2012

File Status 39 is come for file attribute mismatch not for empty file opening ....For Empty vsam file u will get the error 160

Answered by: senthilMainfee on: Dec 1st, 2009

Status code 39

Soc7 abend record identification

Asked By: sekharjchandra | Asked On: Oct 22nd, 2008

How to identify the record that caused the soc7 abend in a batch program? Suppose there are 1000 records in the input file. How can we find the exact record?

Answered by: santosh siliveru on: Apr 11th, 2012

The diagnostics provided with the S0C7 will help you identify which value is not valid. If your site has Abend Aid or one of the other abend analysis tools Index or Subscript is uninitialized, Incorr...

Answered by: fazil on: Mar 24th, 2009

If the cobol program is compile with option FDUMP. you can see the input record which caused the abend CEEDUMP and also the field which cause the error. Something like this.QTY-ACCEPTED  &nb...

Pass values from cobol to jcl

Asked By: sudhakarvunnam | Asked On: Aug 17th, 2010

How can we pass values from cobol to jcl?

Answered by: mannurusrinivasulareddy on: Mar 15th, 2012

we can pass values from COBOL to jcl is only through Files
through return-code we can pass only return code through COBOL to jcl

synt:- Move 16 to Return-code and this can be access in jcl through cond parameter of the jcl step.

Answered by: madhavi on: Jan 19th, 2012

The above 2 ways are to send data from JCL to COBOL not from COBOL to JCL

Access vsam from cics

Asked By: sprabodhini | Asked On: May 5th, 2008

How to access vsam from cics?

Answered by: vinay kona on: Nov 16th, 2011


if you want to use the VSAM in CICS ,first we need to register the file into cics online table called FCT (FILE CONTROL TABLE) . for that we have to write like.,
CEDA DEF FILE(FILENAME) G(VVVV)
CEDA DEF FILE(FILENAME) G(VVVV)

THEN IT WILL BE READY FOR EXECUTING IN ONLINE

Answered by: lalit.kapila on: Jan 30th, 2009

Same as mapset we have to define and install the File in CICS by using CEDA command.

Read sequential file

Asked By: vijaysimha | Asked On: Jan 21st, 2009

How to read sequential file in reverse order?

Answered by: mannurusrinivasulareddy on: Oct 10th, 2011

open file in reverse

i.e OPEN input file-name Reverse

Answered by: mf.vannan on: Aug 12th, 2010

Hi guys

input file
======

a
n
d

to get outupt
==========

d
n
a


if you use the desc sort, output will be display as z to a

if you insert the sequence no on file, than sort to get reverse order.

syntax is

OUTREC = (1, 5, SEQNUM, 5, ZD)

sequence no will be stored in 6 to 10



Regards
Rasipuram Manivannan M

Sort data in file

Asked By: ravtej556 | Asked On: Jun 27th, 2010

In cobol, how to sort data in a file without using the sort command?

Answered by: mannurusrinivasulareddy on: Oct 5th, 2011

ws-rec is an occurs clause variable name. "cobol perform sort-para varying I from 1 by 1 until I > (no of records) after J from I by 1 until J > (no of r...

Answered by: hemanth.pesce on: Sep 29th, 2011

Move all the records to array table.
then compare with each other,then swap that two records.
like IF ARRAY(I) > ARRAY(J)
MOVE I TO WS-DATA
MOVE J TO I
MOVE WS-DATA TO J
ELSE
COMPUT I = I + 1
PERFOEM SAME PARA UPTO FS = 10

How to find the total record occurrence count ?

Asked By: katar_s | Asked On: May 5th, 2011

Answered by: mannurusrinivasulareddy on: Oct 5th, 2011

Here is the answer for your question "cobol IDENTIFICATION DIVISION. PROGRAM-ID. RECCNT. ENVIRONMENT DIVISION. INPUT-OUTPUT SECTION. FILE-CONTROL. SELECT IN-FILE1 ASSIGN TO DD1...

Maximum size of dfhcommarea

Asked By: kunalkishore | Asked On: Apr 16th, 2010

What can be the maximum size of dfhcommarea?

Answered by: hemanth.pesce on: Sep 29th, 2011

64k

Answered by: ravikumar.m on: May 12th, 2011

64 k

What does return code code 0099 mean?

Asked By: sumana sarkar | Asked On: Nov 7th, 2007

One of my jcl steps returns the code 0099 and my job fails.

Answered by: Vijay on: Sep 1st, 2011

Is this a FTP job? If so, the reason for the abend would be Connection to server interrupted or FTP timed out.

Answered by: teddy on: Dec 28th, 2007

if you are working with files or db2 may be a record in it is locked. just relese the lock and try again.

Sort duplicates in dataset

Asked By: Mainframeguy | Asked On: Mar 26th, 2008

How do I use sort to copy duplicates in a dataset to another

Answered by: siddup143 on: Aug 6th, 2011

by using soft utility we can copy the duplicate regards of one file to another file.

Code
  1.   //SYSIN DD *
  2.       SORT FIELDS=COPY
  3.       SUM FIELDS=NONE,XSUM
  4.  //SORTXSUM DD DSN=OZA040.PC.DUP.FILE,DISP=OLD
  5. /*

Answered by: Vijay1979 on: Mar 9th, 2011

//DDName EXEC PGM=SORT//SORTIN DD DSN=XXXXXXXXXXXXXXXXX,// DISP=SHR//SORTOUT DD DSN=XXXXXXXXXXXXXXXXXXXX,// DISP=(NEW,CATLG,DELETE),// UNIT=XXXXX,SPACE=(XXX,(XX,XX),XXXX),// DCB=(*.SORTIN) Output file...

How to recover a gdg version when it is deleted?

Asked By: kumar | Asked On: Oct 15th, 2007

Answered by: katar_s on: May 6th, 2011

If u know vol serial number , u can get it by using the VOL=SER= VALUE

Insert number of row into table

Asked By: ysrinu87 | Asked On: Feb 4th, 2011

How to insert number of row into table in cobol db2 programe?

Match data from table in db2

Asked By: RahulGaikwad | Asked On: Jan 8th, 2011

How to match the data from table in db2 to application prog in cics?

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.