IBM Mainframe Forum

Hi,

I have two tables X1 and Y1, the table X contains a records as shown in the below

X1 table data


Y1 table data

The common colums are X1 Table ID attribute and y1 table , FK_ID attribute.

What I want here is when status is '2' then X1 data should not come and when it is '4' then X1 data should come .

Many Thanks In advance

CODE' D and ALIGNED
To make things more readable for the people who will spend their time trying to help You

And if status is 3?

Hi Akatsukami,

Thanks for the reply.
And, there is not status '3' , only 2 and 4.

Many Thanks

What is your output - only the X1 record or data from y1 as well? Do the records have to match on ID? If so what then. Looks like a simple query if you are matching on ID and y1,status = 4. What problem are you having? What have you tried?

Thanks Nic for the reply.

My requirement is when status is '4' then only delete X1 record but problem is even for status '2' the X1 record is same .
When tried this query



The output is X1 table record and when change to STS to '2' same record will display because X1 record is same for both status.
I think, If I delete Y1 table sts '4' records first then it would be fine ? so no need to go for above stuff ?

Many Thanks

CODE' D AGAIN

Why not try it? And use the code tags when presenting code, data, control cards etc.