what operation is performed by job statement?

1181

Explain the purpose of the file status clause in the select statement?

1038

When do you get -811 sqlcode and how to resolve it?

1068

Can we delete records from view?

1026

Difference between fixed length and variable length records.

910

what is 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?

1236

Explain the significance of dbid used in adabs?

1047

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?

1032

Explain the disadvantage of dynamic generation of acb?

994

What is the advantage in De-normalizing tables in DB2?

1240

How can you do the explain of a dynamic sql statement?

1115

What is a transid?

1150

Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?

1216

what is the meaning of ssrange and nossrange?

1063

What are the some important fields in the eib block?

1242