IBM MainFrame Interview Questions
Questions Answers Views Company eMail

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

UST,

1 5134

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

Infosys,

4 9736

How to replace the GOTO statement in COBOL without changing the structure of program. e.g. consider following code... I.D. E.D. D.D. P.D. compute C = A + B. GOTO para 100-display. compute D = C - D. GOTO 200-display. some other logic...... ........ GOTO 300-para. ...... ...... GOTO 400-para. Now I want to replacce all GOTO statements without changing the structure and otput of program.

Accenture,

6 20529

I have program P1 which calls file F1 which has 100 records and following structure 001 .................. 002 .................. 003 .................. 098 .................... 099 ................... 100 .................... Now I want to read these files and write these records in file F2 in following manner. 001 ...... 051 ..... 002 ...... 052 ..... 003 ...... 053 ..... .......... ....... .......... ....... .......... ....... 048 ........ 098 ...... 049 .......... 099 ....... 050 .... 100 ......

Accenture,

4 10525

Why we need to use redefine clause when we can define the variable seperately... what is actual need....

Accenture,

5 12784

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

Infosys,

3 9139

how we will do null data selection in cobol-db2 program

Wipro,

2 6008

How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?

1 7582

copy 100 records without using ibm utilities

3 7609

record length in spool?

Infosys,

2 5785

what is the use of outrecord?

1759

a job have 5 steps and it will executes a proc which have 5steps in it. now i have to execute step3 only when step2 of proc executes successfully

3 6246

what is Retro fitting ?

CTS,

1 3698

what is SMP/E? and what are the major steps of it? thanks...

IBM,

1 8340

what is a zoned decimal data type and how it will be stored?

IBM,

2 7234


Un-Answered Questions { IBM MainFrame }

What is the local-storage section?

668


What is the maximum length of a single line of jcl?

814


can oorexx run ibm object rexx programs?

593


Define an asra abend?

590


What are the types of record locks and how are they set?

1213






Explain how can the submitting users racf authority be overridden in a job stream?

661


What is recovery parameters in define cluster command?

553


What is a report item?

729


How to define a vsam file in cics getting into cics to define a vsam file.

593


Mention the downsides of page level lock.

696


What is database reorganization?

579


Explain the advantage of creating the acbs well ahead of time?

3132


Explain the maximum number of levels allowed in ims db?

3326


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

646


What is cursor in dbms?

577