Date: Wed, 31 Oct 2007 07:14:35 -0700
Reply-To: Sander Burggraaff <info@BURGIE-T.NL>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Sander Burggraaff <info@BURGIE-T.NL>
Subject: Re: SQL transformation in DI Studio
Content-Type: text/plain; charset="us-ascii"
> Yes you can! Its a little bit tricky but you can! You can use an outer-
> join with a case statement!
I guess I don't understand what Jaheuk is trying to achieve because as
far as I can see the code supplied bij And does not update an output
dataset. If I'm not mistaken then Jaheuk wants to update the temporary
dataset in the SQL Join transformation which would be represented by
the ccc table in And's example. But And's code doesn't update the ccc
table. It merely creates that table...
So who can shed some more light on this question?