Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



IBM MainFrame Interview Questions
Questions Answers Views Company eMail

How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)

HCL,

3218

In the house keeping section of an MVS assembly language program, like the one below STM R14,R12,12(R13) BASR R12,R0 USING *,R12,R11 LA R11,2048 LA R11,2048(R11,R12) .... .... 1. What if BASR R12,R0 IS NOT PRECEDE USING *,R12,R11? 2. USING (base address), REGISTER does USING directive says assembler to treat particular Register as a base register with the mentioned base address..in the above case * i.e current location counter..well if that is the case why we need BASR R12,R0 ? 3. What if I write like STM R14,R12,12(R13) BASR R12,R0 LA R11,2048 LA R11,2048(R11,R12) USING *,R12,R11 there is no address resolution being calculated in both LA statements so is it a right way to set Base register?..will there be any issues with Domain regarding R11 and R12?

1934

What does LA R3,R3 ?

Amdocs,

1 3146

What is SQL Code -904 and -903 in DB2 And how to handle it?

IBM,

1 7204

Why we should use cursor ?

3 4126

I know my query will return more than one row but I don't want cursor what should I do?

1 3355

How can you get the number of rows impacted by the last executed query?

1 2739

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

JPMorgan Chase,

2291

How to fetch the uncommited data from table ?

JPMorgan Chase,

1 3560

Difference between Find and Read operation in ADABAS file.

Cognizant,

1 5398

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

Cap Gemini,

1 2461

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

TCS,

1 3141

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

TCS,

1 3111

I have 60 steps in the JCL and want to Execute Only First from PROC by overriding in JCL ?

1794

How to override loadlib?

Fiserv,

1973


Un-Answered Questions { IBM MainFrame }

i made it to stage 3 of an interview process wednessday they will quiz my knowledge again face to face for an analyst role recruiter said it will be based on Business requirements system is cobol and good ideas what they might ask etc

2549


State the differences between vsam and non-vsam files?

997


Give a brief description of db2 isolation levels?

1022


INCLUDE is used ONLY on MVS/ESA Version 4 or higher systems to name an INCLUDE group. An INCLUDE group is a set of one or more valid JCL statements that are stored together in a JCLLIB data set or a system procedure library, and that are read in and used to replace the INCLUDE statement itself within the job. Any number of INCLUDE statements can be used in a job, but the name field value used on each should be unique within the job. The INCLUDE statements can appear in a job anywhere after the JOB statement, but may not appear between a CNTL and ENDCNTL JCL statement.

2197


Suppose if there are a set of statements and each has a word “value” in it, if I want to display all these statements so that the word “value” is aligned, then how do I code this in rexx?

917


What is db2 stogroup?

1113


What is a hyperdescriptor?

898


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

1048


What is a db2 package?

1008


Define communication area?

941


How do u write test cases?

2029


Explain the uses that are associated to tsq and tdq ?

1047


name the utility program closely associated with vsam?

995


When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?

1413


What language is db2 written in?

990