MVSFORUMS.com

[psridhar]

Hi

I have two tables with their columns as follows.

[kolusu]

psridhar,

Try this

[videlord]

Is your requirement feasible?
If no unquie constraints on TBC1 TBC2 TBC3,
then how to set TBA4?
more than 1 possible value

[psridhar]

Hi Kolusu,

I tried your SQL and got the results. Thanks for the help.

I faced one problem while executing the SQL. I have some rows in TB which does not have corresponding rows in TA satisfying the WHERE. I got SQLCODE = -407. I deleted all such rows in TB and ran the SQL again and it gave correct results.

My understanding is, if a row in TB does not have corresponding row in TA then there should not be any updates to that row in TB. But why SQLCODE = -407.????? Can you please reply me if you have time.

Thanks and Regards
Sridhar P

[videlord]

The SQL would update all records in TB.
Consider this scenario, for one record in TB, there is no record inTA match this record with the 3 column.
Then the SQL is same as
UPDATE TB set TBC4=NULL where TBC1=xx and TBC2=xx and TBC3=xx

if TBC4 is define with NOT NULL, SQLCODE -407 appeared.

[kolusu]

psridhar,


Videlord is right on about the column declaration. If the column is defined as NOT NULL then you would get a sqlcode of -407

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[NASCAR9]

This is how I get around SQLCODE -407:

[Dibakar]

Hi,

I have never written sql, probably so, i don't understand why kolusu's code worked and sridhar's didn't. Since column names are diffrenet in both the tables, does the x and y alias really matter.

thanks,
diba.

[kolusu]

[Dibakar]

Kolusu,

Thanks for your clarification but I still have doubt.

Suppose this is my input -