How to remove 2 duplicate records and copy only one using job control language?

1219

What is defragmentation and what is its advantage?

1294

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

Explain the difference between a return with transid and xctl? For example program. A is issuing return with transid to program b. Program a. Is isssuing xctl to program b?

1048

What is a set in idms? What pointers are required, what are possible? How may sets be ordered?

863

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 ?

2331

What is catalog database in db2?

1165

Mention the downsides of page level lock.

1161

How to List the Available Tables?

1688

What is the difference between cursor and select statement?

1103

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

1045

On which levels locks can be applied?

1133

What are various loop types supported by rexx?

948

What are the parameter we cannot use in procedure?

1133

What is db2 and what is the use of db2 optimizer?

1068