Interested to Buy Any Domain ? << Click Here >> for more details...
What is Call attach facility? How does it work?
- 1 Answers
- 12873 Views
- Syntel, I also Faced
- E-Mail Answers
Answer / mani
Call Attach Facility is used for application programs that
run under batch to establish a connection with db2.It is an
alternative to DSN command processor and provides greater
control over the execution environment.
Programs using CAF can
1)Access DB2 from address spaces where there is no TSO,
CICS, or IMS
2)Access the Instrumentation Facility Interface (IFI)
3)Access DB2 from multiple tasks within an address space
4)Control the connection to DB2 explicitly
5)Connect to DB2 implicitly, using a default subsystem ID
and plan name
6)Receive a signal from DB2 on start-up or shutdown.
The Call Attach Facility is being slowly replaced by the
more powerful RRS (resource recovery services) attachment
facility.
| Is This Answer Correct ? | 5 Yes | 2 No |
How many clustering indexes can be defined for a table?
What is an intent lock?
How do you define a correlated name?
When Can you be sure that a query will return only one row?
How does the processing of a correlated subquery differ from a non correlated subquery?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
How can you do the explain of a dynamic sql statement?
What is db2 plan table?
What is db2 isolation?
How to execute stored procedures?
How can you split a table in to exactly half?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
COBOL 
