What is defragmentation?

1109

Whats the difference between search & search ALL?

6535

Explain how are you going to remove duplicates from the file that is being read?

1009

suppose I have two tables a and b. Both tables are connected with ssn number as foreign key. I want to retrieve a column data from b table. How will you write a query?

975

What are some jcl statements that are not allowed in procedures?

1236

how can we apply for HSBC exam(Mainframe) in India??? i went to their site and was told to submit my CV ,. etc..( totally confusing...)

2400

Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.

2424

How to execute 2nd and 4th steps among 5 steps in jcl proc?

1326

without jcl how to run the batch programs

2534

How many maximum base registers we can have in a program?

1031

What are host variables in db2?

1072

How do you concatenate the firstname and lastname from emp table to give a complete name?

1077

How to alter the parameters for the existing gdg?

1204

when an apllication is invoked via the exec cics start command with the from option, how does the application gain access to the common area?

1077

What will happen if both steplib and joblib are determined?

912