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


MainFrame Interview Questions
Questions Answers Views Company eMail

how will you retrieve first record in table

UST,

1 5428

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 5158

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 9796

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 20645

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 10629

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

Accenture,

5 12856

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 9183

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

Wipro,

2 6053

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 7611

copy 100 records without using ibm utilities

 3 7653

record length in spool?

Infosys,

2 5851

what is the use of outrecord?

 1772

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 6300

what is Retro fitting ?

CTS,

1 3719

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

IBM,

1 8398

Un-Answered Questions { MainFrame }

What is house keeping in assembler?

593

if we tried to move year part of *iso date into a field of length 3, what will happen ?

658

What is the use of predicate?

588

How do I optimize a query in db2?

624

Explain the difference between record occurrence and record type?

1668




Can you explain common systems area?

662

What is the difference between run mode and addressing mode?

638

Kindly specify the pic clause for the hhmmss type of data fields?

653

What is the role of union all and union

651

What are the types of important programs that are used in the cics?

615

How to check sequence on a table in db2?

601

How many module come in Ibm framework?

1547

where will control be passed after the execution of the *pssr subroutine if the factor2 of the endsr is blank ?

1124

what does defn do?

616

WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

2038

For More Un-Answered { MainFrame } Questions Click Here