|
Question |
Rating |
View Answer |
|
How would you retrieve rows from a DB2 table in embedded SQL? ? |
|
View Answer |
|
Suppose there is cobol-db2 program.I made changes only in the cobol program.Is there need recomile the DBRM again?why?
|
|
View Answer |
|
39) Is DECLARE TABLE in DCLGEN necessary? Why it used? |
|
View Answer |
|
43) How can you quickly find out the # of rows updated after an update statement? |
|
View Answer |
|
What will happened .if the file is open in extend mode and corresponding is equal to old in jcl?
|
|
View Answer |
|
What is maximum number of one storage group?
|
|
View Answer |
|
How to retrieve n-th row ie n-th record of any table irrespective of the columns and the values present in the table without using ROWID(As it is not supported in DB@)
|
|
View Answer |
|
How to increase table space in db2?
|
|
View Answer |
|
What is an alias and how does it differ from a synonym?
|
|
View Answer |
|
36) What is DCLGEN ? - |
|
View Answer |
|
89) What is a clustering index ? � |
|
View Answer |
|
56) What are the disadvantages of PAGE level lock? - RAMESH www.geocities.com/srcsinc |
|
View Answer |
|
49) How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.) |
|
View Answer |
|
What are the disadvantages of using VARCHAR? |
|
View Answer |
|
Why SELECT * is not preferred in embedded SQL programs? |
|
View Answer |
|
How do you do the EXPLAIN of a dynamic SQL statement? |
|
View Answer |
|
How will the program knows which key has been pressed?
|
|
View Answer |
|
How do you specify and use a cursor in a COBOL program? ? |
|
View Answer |
|
19) Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project? |
|
View Answer |
|
28) Is DECLARE CURSOR executable? |
|
View Answer |