MainFrame Interview Questions
Questions Answers Views Company eMail

I've one sequential file, That file contains millians of Junk & CHAR recoreds example File 1 ,,,,,...,,,.....,.,.INFOSYS.....,,,,,,,,,,,WIPRO..........., ,...,..,. My questions is : I want omit the 44th posstion to 4 CHAR (WIPRO) remaining things I want output file (including Junk CHAR also)... How can we slove this problem & give me a syntax. Please provide the result as soon as possible.

CTS,

5 9320

i have two flat files.i want to select one record from that file by using jcl.for example file1 contains emp no,name,joining date. file2 has same details.emp no is primary key. i will give empno.that emp details send to outfile.please let me know if any one knows it.give sample code.

TCS,

1 6282

i would like to know under what circumstance the object will get locked on AS400.

IBM,

5 9230

How to find in aparticular step how many versions a paricular gdg base have?

TCS,

4 17338

Can we use an equated value as operand for an MVC instruction? Reason for the same

IBM,

8 10415

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 7144

what r drawbacks of OPM? Why do we go for ILE RPG?

1 9807

How can I find the maximum value of a field in a file while reading the file dynamically? without using sort function. Suppose i have a file with fields Timestamp, description, teamname, teamnumber.. i have read the file till end and find the maximun value of timestamp which is not in sorted order.. can we use function max(timestamp)?

CGI,

1 12096

What are the steps to retrieve the records from Journal file...?

1 10913

I have the transaction name for cics screen.. With the transaction name, how will I find the cics program written for the transaction and BMS map program also...

CGI,

4 14732

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 5222

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

UST,

4 6567

Is it possible to mutliply a comp variable with an comp-3 variable. Will there be any error if i do it?

IBM, UST,

3 8622

If i have defined an temperory dataset in step2, how can i call back or use the same dataset in step5 of the same job

UST,

4 8311

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

UST,

3 5962


Un-Answered Questions { MainFrame }

How do you select a row using indexes in db2?

643


in ways data can be passed to a COBOL program from JCL?

663


Can QSAM files be accessed from CICS?

678


Explain the advantage of dynamic generation of acb?

2807


suppose I have 1000 rows in a db2 table. I want to update first 100 records, how do I do it?

677






can you debug ile rpg program using isdb?

732


what is data area and how it is used in rpg program ?

750


What is the interactive job?

574


What is db2 purescale?

543


How are data passed from jcl parm to assembler program?

581


What is the use of member in pf?

536


What is database reorganization?

587


What is catalog database in db2?

640


explain in brief what are the 3 types of vsam files?

628


What is the usage of comp fields in cobol?

652