MVSFORUMS.com

Manas,

I have read in manual that DECLARE GLOBAL TEMPORARY TABLE is issued in program to create an empty instance and then INSERT , DELETE, UPDATE can be used in GTT. In what cases these are useful ...

Thanks Manas & a_seshu. I realise, I am out of my mind when I am posting this question. Here is the reason why it happened.

Currently I am also working in IDMS, here when deadlock happens we cl ...

Manas,
That was an excellent explanation. Thanks for your detailed reply.
I got the complete picture now.

Regards,
Hema

Hi Kolusu,

Thanks for your quick reply.
I have already referred this link. But I could not understand the relation between scrollable cursor and GTT , on how they should be operated together ?? Pl ...

Hi,

I have learned that DB2 uses a declared temporary table to hold and maintain the data returned by a scrollable cursor.

Below is SENSITIVE STATIC SCROLL cursor, how should I use declared temp ...

Hi,

Is there a delay command in DB2 ?

Suppose if I have batch DB2 pgm, and if I encounter deadlock then I want to delay for 3 min and then again perform the same statement to avoid deadlock. How ...

Hi,

How many types of cursors are there in DB2 ??

I got 2 different types of answers as below

Ans 1) Scrollable, non-scrollable, held, non-held cursors

Ans 2) Static, dynamic, Forward-only ...

Hi,
The STARTBR command establishes the position within the file but does not retrieve a record. Here based on key value, position is set in the file. So it depends on your requirement

HTH
Hema

Hi,
After creating a primary key for a table, why is it required to create unique index on primary key column ? I saw in most of the shops this standard is followed. Please advise.

Thanks
Hema

Hi,

I have a new program written in MQ running under CICS.
what is the setup that needs to be done to initiate a cics transaction when ever the data arrives in queue ?

Thanks
HemaNew program ...

Hi,

I have a new program written in MQ running under CICS.
what is the setup that needs to be done to initiate a cics transaction when ever the data arrives in queue ?

Thanks
Hema

Manas,

Its nice to see the 2 thumb rules. I believe, I have understood the difference now.

But one small correction to what you said. EXEC CICS RETURN implies an implicit SYNCPOINT at the highes ...

Thank you Jeba & Manas. That was a very nice explanation.
MVSFORUMS is a great group. I am happy to be part of it.

Thanks
Hema

Hi Kolusu,

Thanks for clarifying my second point.

Regarding the first point, per your advise I have read the link again. See the below lines from that link. It says that it would rollback all t ...

Second option is the best

Thanks
MHS