IBM MainFrame Interview Questions
Questions Answers Views Company eMail

In a Natural program i used the below code for report FORMAT LS=132 PS=60 And down the line I want to change either LS/PS like FORMAT LS=120 PS=50, is it possible? How it will work?

1428

I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK

IBM,

1471

what happens if parmparameter passes zero bytes to the program

HSBC,

1648

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

HSBC,

1 2887

Do we need to code DCB parameters when using DISP position as MOD?

Accenture,

1 3746

Why do we use COMP-3 variables for computation, when we know that they are non displayable fields and require additional MOVE to numeric field before we populate it in output Reports?

Accenture,

1 5692

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1222

I have a program with an Array of 5000 occurences which is being passed from 5 sub levels to the front end screen. Thess 5 programs using each 5*2 = 10 different arrays with size as 5000. This is causing the transaction to utilize more storage consupmtion. I am looking to reduce the storage consumption. As part of that initially i thought Dynamic array may solve my problem. After viewing the comments given i see its same as normal array. IS there any other way we can resolve this issue?

HCL,

1217

What will happen, while trying to close the closed cursor.

1 1966

In a file if a column account number conatain value 0001234.. how can we move the value to another variable without zero. value may contain any type such as 00123405. we need the value 1234 or 12305. how can we do that in cobol. Please help.

CSC,

1 2649

If a file has 1000 records.. if i have to replace the first and last characters of the file with another character. how it can be done....

HCL,

1 3231

If my program receives input feed from program in other system.. if the receiving field size is less than the sending field.. what abend will be happening.

HCL,

1 1926

How to restart a DB2 program?

Cognizant,

1349

how to compare two datasets without using superce because output is limited to 133 bytes

1469

what are the types of abends that occur on job failure? And explain the possible causes of these

1106


Un-Answered Questions { IBM MainFrame }

is it required that primary key values have to be unique? Do alternate key values have to be unique?

590


How to find occurrence of mu and pe fields in a file?

479


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

590


What is the eib parameter?

602


how do we describe cataloged procedure and an instream procedure?

605






which is Best IBM Mainframe Training and Placement Institute in Ameerpet Hyderabad

1007


What is the difference between the positional and keyword parameters? Give examples.

686


What is the importance of common attribute?

573


How would the varchar column remarks defined?

616


what is the meaning of dynamic processing in vsam?

576


What is database alias db2?

586


Explain the purpose of dd dummy statement?

658


What is the use of value function?

611


What is the difference between Global and External Variables?

652


Explain in brief how does db2 determine what lock-size to use?

582