| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is a plan and how do you refer the plan in the
program? | Xansa | 2 |
| What is an alias? | | 2 |
| If I have a view which is a join of two or more tables, can
this view be updatable? | | 2 |
| where can we use index and subscript ? with example ? | CTS | 2 |
| How do you prepare a COBOL + DB2 program from coading till
execution ? | Xansa | 1 |
| What else is there in the PLAN apart from the access path? | | 1 |
| What is the SQL Communications Area and what are some of
its key fields? | | 1 |
| Explain what a plan is? | CTS | 2 |
| What is a cursor and what is its function? | | 2 |
| Can a array declared with an index be displayed(readable
format) in spool? | UST | 4 |
| If a non-DB2 program calls a DB2 program, the calling
program's name will be there in SYSIN of IKJEFT01 and the
plan name will be that of the called program. But is a bind
needed or a plan has to be created for the non-DB2 program
also? | | 1 |
| What are the various locking levels available? | | 2 |
| insert into tablename a
column1,
column2
select column1,
column2
from tablename b
i am getting abend -104..can any one help? | Syntel | 3 |
| can i code union in cobol-db2 pgm ? | Patni | 2 |
| When will you chose to run RUNSTATS? | | 1 |
| What is referential integrity? | | 5 |
| Explain transactions, commits and rollbacks in DB2. | | 3 |
| Name some fields from SQLCA. | | 2 |
| If the base table underlying a view is restructured, eg.
attributes are added, does the application code accessing
the view need to be redone? | | 2 |
| Hi i need to write a query on the following requirement.
SELECT COMM_TEXT
INTO :WS_MIKM_COMM_TEXT
FROM MPIPROD.MIKMV01
WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO
AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT
AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC)
OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT)
The above query is to be modified. The requirement is if
both the fields are equal then that has to be given
priority. In the above query if it satisfies any one it
comes out without checking if both being equal is possible. | | 1 |
| |
| For more DB2 Interview Questions Click Here |
Site Map
