MainFrame Interview Questions
Questions Answers Views Company eMail

why we code ACCUM parameter in cics send time

1 6807

i have 10 steps in my jcl. -->if i want to execute my program from 5th step what i have to do? don't give //* in ur previous steps --> if i want to execute my program from 1to 5 steps only what i have to do?

2 5646

I have a PS file and I would like to manually insert the binary values (like a COMP format) into the file. How can i do that? the way do in COMP-3 format.. suppose i want to insert -12345 in to file in comp-3 format. simply we can open a file in edit mode and do HEX-ON and insert the value . SEE BELOW-- 135 24D in 3 bytes - this will be COMP-3 presenatation of -12345.

1 5980

what is ment by "MDT"

TCS,

2 6597

what is file identifier wher we can use

IBM,

1 5114

what are the types of identifers

IBM,

2 6106

Why we cannot call a service program? If I add a PEP can i call the service program?

DELL,

1 6734

I have a File that has duplicate records. I need only those records that occur more than thrice.?

IBM, Wipro,

3 8660

1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

IBM,

2 10072

in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

IBM,

2 5174

1.Suppose my file has 10 fields and I want to make the 2nd field Zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation? 2. Assume my file has 100 records and I want to see only first 10 records. Is this possible through LF? 3.I have 3 jobs A B and C. I want to submit B after successful completion of A and want to submit C after successful completion of B. Without using job scheduler or job queue, how can i do that through CL program? 4.What is difference between Bind by copy and bind by reference?

Virtusa,

4 9505

1. If my rpg program has a date field, What extra care I have to take while compiling that RPG program? 2. If the file is keyed and I have declared the file as well as Key list properly in my program. Still am getting an error message like "Chain/reade operation is not allowed" What may be the case?

Virtusa,

6 9543

In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)

2 7587

Hi All, In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)

1 4723

how to remove leading spaces and zeroes in a cobol variable.is there any easy way to do it

2 20756


Un-Answered Questions { MainFrame }

Which command is used to connect to a database in DB2 ? Give the Syntax.

602


what do you mean by a shareoptions parameter (shr) in define cluster command?

602


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3121


Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?

758


Explain how to differentiate call by context by comparing it to other calls?

689






Explain the difference between dfhcommarea and tsq?

554


Explain how to build up lu 6.2 communication?

618


Why do we need integrated cics translator?

631


what is search and searchall?what is the diffrence between them?give an best example?

5563


Can you define commarea?

563


Explain the function of //cntl statement?

661


How to Define a Procedure in RPG?

1226


Explain how can the attributes of one sms dataset be copied to another dataset?

707


What are the various section in data division and briefly explain them.

700


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6863