can any body give me the answers asap
when can u say that a query return only one row?
have u worked on performance improvements of sql queries? if yes how do u analyze the performance of the query?
what are the ways ucan release exclusive access acquired over the control intervel during Read Update?
what r the compiler options with which ur cobol programhas to be compiled to use in cics region?
which is the parameter of the DFHFCT macro that is used to translate all lower characters to uppercase for 3270 terminal?
6)which is the aid that willnot be identified in the any key option of the handle aid command?
what facillity connects cics and db2?
8) how to submit a jcl from a cics program?
1) when can u say that a query return only one row?
ans: use primary key in where clause
6) which is the aid that willnot be identified in the any key option of the handle aid command?
answer : ENTER Key
7) what facillity connects cics and db2?
A mechanism named the CICS Attach Facility connects CICS with DB2. Using the CICS Attach Facility, you can connect each CICS region to only one DB2 subsystem at a time. You can connect each DB2 subsystem, however, to multiple CICS regions simultaneously. DB2 provides services to CICS via MVS TCBs. Furthermore, the resource control table (RCT) must be configured for each DB2 program that will run under CICS. The RCT applies only to CICS transactions that access DB2 data; it defines the manner in which DB2 resources will be used by CICS transactions. In particular, the RCT defines a plan for each transaction that can access DB2. Additionally, it defines parameters detailing the number and type of threads available for application plans and the DB2 command processor.
I have given answer in detailed way u should understand it
4. what r the compiler options with which ur cobol programhas to be compiled to use in cics region ?
answer: actually whether answer corret / not some have to verify it . For COBOL - CICS program in compiler options u should put y for CICS. Path for TRANSLATOR , PDS path for cics COPY book & RCT details etc