What is a Resource Control Table(RCT)? Describe its
characteristics.
Answers were Sorted based on User's Feedback
Answer / s
CICS RCT defines the connection between CICS and DB2.
| Is This Answer Correct ? | 18 Yes | 3 No |
Answer / nag(igate)
All db2 plans should be registered in the RCT
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / guest
RST defines the relationship between the CICS transaction
and DB2 plans.
| Is This Answer Correct ? | 6 Yes | 2 No |
When Can you be sure that a query will return only one row?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
What is a DBRM, PLAN ?
What is release/acquire in bind?
Can you use max on a char column?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is JOIN and different types of JOIN.
what are the bind parameters?
Describe what a storage group(STOGROUP) is?
Do we need cursor for Count(*)?
What language is db2 written in?