MVSFORUMS.com

Thanks Kolusu for the reply.

In my initial query, TABLEA A in one region and TABLEA B,C,D are in other region. Initial query has a different names for TABLEA B,C,D which are Data Proped from TABLE ...

Also, the counts doesnt match. Here is the O/P of the suggested query:
+-------------------------------------------------------------------------------
| DTNCNY | DTNSLIC | SVCTYPE | SMTLETTER ...

Thanks Kolusu for looking into this.

get all the 3 tables as a single table and then use that result table to join

1) There is only one table involved here. TABLEA
2) If I use the approach ...

Hi,

Iam trying to optimize this query:
Query:

SELECT DISTINCT A.SMT_DTN_CNY_CD DTNCNY
,A.DTN_SLC_NR DTNSLIC
...

Helo,

Below is the query that Iam trying to Optimize:

SELECT
COUNT(DISTINCT E.SMT_NR)
, COUNT(DISTINCT F.SMT_NR&# ...

Hi All,

We have MQ triggering the application program-1 when the first message comes on to the MQ. This program-1 calls program-2. We are using external copybooks to pass the MQ data from program-1 ...

Hi All,

I have records on MQ. I need to read each record and store it in a table as free form text area.
This record will be multiples of 130 bytes. The colum in the table can hold upto 76 chunks ...

Thanks Kolusu!

Hi,

I got the solution. Below is the query I used:
(Test_Area is 40 bytes and last 6bytes is the date)

SELECT *
FROM TABLEA
WHERE
(SUBSTR(Test_Area,34,2) > '50' ...

Hi,

I have a DB2 table where one of the colum is Text_Area (Datatype: Varchar). This Colum stores the date field(format: YYMMDD).I want to query this table to fetch all the rows greater than
a pa ...

Hi all,

I have a copybook of lenght 2000bytes. I read the MQ record into this copybook(generally the mq record is about 1500 bytes).
If the processing of this record fails, I want to write this me ...

External Copy books are defined with the word "EXTERNAL". If a program calls another program in CICS, it need not pass any values. Instead both programs can use the variables in the EXTERNAL ...

Hi All,

Can I use External Copy book to pass data between two CICS applications to overcome the COMMAREA limitaion of 32K. I am finding some material on CICS containers which overcomes the same pro ...

To make my question more clear, While using the CICS TSP processing can I implement the Message Handler program functionalities in the Application program. We have 11 MQ's in our design. If we can eli ...

Hi,

While implementing "Web Sphere MQ