| Other DB2 Interview Questions |
|| Asked @
|What is image copy?
|What is lock contention?
|In cursor program-1 can we create another cursor program-2
inside the cursor program-1.If yes how/no why ?
|Can DB2 be accessed by TSO users? If yes, which command is
used to invoke DB2?
|cobol-db2 runjcl please?
|suppose in my table 10 rows are there , i want to update odd
rows salary as 90000 ? how u do it ? any one help me ? what
do we use here cursor-fetch or normal sql ?
|What is a cursor and what is its function?
|if there is a table with huge number of records and if i
want to extract only first 3 records from the table, what
query i have to provide to retreive first 3 records
|What is meant by index cardinality?
|Hi this is sures. i need to practice the ibm
mainframes.could u telme how can i get userid from IBM.how
much cost they will collect for one user id.can send me the
|1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB
and PGMB calls PGMC. I have to do inserts, updates in all
the 3 pgms.
2) Say PGMC has done its work successfully and returned to
3) PGMB had an SQL error while doing some update
4) PGMA has already done some updates before calling PGMB
all are running under the same CICS region.
What will happen if I issue SYNCPOINT ROLLBACK in PGMB when
it abends ? Does all the changes in PGMA,B,C rollback ?
(because all the pgms belong to same task).
|What is sqlcode -811?
|For more DB2 Interview Questions Click Here |