MVSFORUMS.com

Suggest me a way in COBOL to add dynamically values to IN Clause in sql.

Example :
During one run of the program the IN Claouse in sql may look like this
IN('IPC1','IPC2','IPC3')

this may ...

Thanks for the reply.

Candle explain comes as part of the DB2 product.They dont seperate applid to login.

I want material for DB2 Explain which comes as part of the DB2 product.

Hi
I hav DB2 Explain of candle product.Could u please anyone provide me how to use this or any material on this is greatly appreciated.

Thanks in advance

Hi,

Following is the index (col1,col2,col3) created on the table TABLE1.In the query col1 and col2 are used in joins and col3 is used in where clause. Whether the index scan takes place or ...

Hi

I could not get u. I am trying to enter an tranid SECU and XCTL to another program which has the tranid SEC3. But the map does not get transferred.It remains in the same map that coreesponds to ...

Hi

In CICS screen when we try to enter the TRAN id it enters into another transaction but the MAP remains the same.
This is not the condition every time.It occurs in location and not in anoth ...

Hi

The Queue manager has the specific queue defined, yet this error happens.Plz explain.

Hi,

Actually the mapping of Transaction and IMS Program occurs in TRANAPPL macro.

I could not find the TRANAPPL macro in IMS.MACLIB library. Could u tell me where this Macro is found and also s ...

Hi,

I could not find the TRANAPPL macro in IMS.MACLIB library. Could u tell me where this Macro is found and also some description about the macro?

Thanks in advance.

Hi

1)In CICS there is PCT table where there is mapping between Transaction id and Program.

Similarly how the correspondence exists between the Transaction id and program in IMS DC.

Is t ...

Hi

I have generated Map and then formatted to get MID/MOD in IMS.FORMAT
library.But i am not able to see the MID/MOD Changes in IMS online screen.

1)Also i tried to give /FORMAT modname

Thi ...

Hi,

I am trying to generate IMS DC Map By executing DFSRRC00 in DLI mode but i am getting error 'MISSING LOGICAL VIEW DEFINITION FOR LV-ID'

Thanks in advance

Hi,
Can anyone explain the usage of ZCMD command in rexx.
Thanks in advance.

How to check the One CICS region CICSBDT0 is connected remotely with another CICS region

Hi,

Applied - I entered the Transaction in both the regions and it works
Access - I am not able to view the Tran id IN CICSBDT0 in Resource manager

When i logged into CICSBDT0 and gave CEMT I ...