Name the various locking levels available?

1093

A table has two indexes defined. Which one will be used by the SEARCH?

1285

Give the format of using and giving in sort statement. What are the restrictions with it?

1038

What is the meaning of a (new, catalog, keep) disposition mean?

1116

how to define a directory and what is the structure and definition for the same?

1063

input 1 input2 ouput1 output2 output 3 1 re 300 1 re 200 1 re 300 3 rc 500 1 re 200 2 rr 400 1 re 300 2 rr 400 1 rc 400 3 rc 500 1 rc 400 2 rr 700 2 rr 700 5 tt 900 5 tt 900 2 inputs r in flat file and output 1 is matched records,ouptput2 is unmatched of input1,output3 is unmatched of input2! how vl u get the output files using sequential order and to check with each and every records! let me know the procedure division ?

2300

What is a vsam dataset?

1033

Ap wkur,=p5 where wkur is a label?

1152

What is difference between alias and synonym in db2?

1143

Is the order of the when clause important in an evaluate statement? Is the order of the when clause significant in an evaluate statement?

955

What is the function of logging in the db2 database?

1123

how to convert the recors form vsam file to db2 table tru file aid

3262

What is difference between isnull and coalesce?

1056

Explain is it possible to code goto statement in natural? If yes please provide the syntax of the same?

978

Sync points cannot be requested by the application programs? State true or false

1162