Date:         Mon, 21 Apr 2008 14:46:02 -0400
Reply-To:     "O'Connell, Martin" <MOConnell@GEICO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "O'Connell, Martin" <MOConnell@GEICO.COM>
Subject:      Re: SAS/DB2 table joins
Comments: To: Mary <mlhoward@avalon.net>
In-Reply-To:  <00ec01c8a3de$f9f4db20$832fa8c0@HP82083701405>
Content-Type: text/plain; charset="us-ascii"

Mary,
 
I create the table via "create global temporary table tname" and
reference via session.tname after creation.  The join actual joins are
behaving so indexing is not needed.  It just takes a long time to get
larger tables up there.  
 
Martin

________________________________

From: Mary [mailto:mlhoward@avalon.net] 
Sent: Monday, April 21, 2008 2:39 PM
To: O'Connell, Martin ; SAS-L@LISTSERV.UGA.EDU
Subject: Re: SAS/DB2 table joins


Also, I'm a bit confused as to whether this is a "session" table or a
"global temp table", as these are two different kinds of temporary
tables in DB2.   I haven't ever used a session table through SAS, but
have many times using PL/1, and was able to add code for the index as a
SQL call just after the declare; you might want to check with your DB2
administrator as to whether you could do that here (or if you are using
a GTT, then consider switching to using a session table).  
 
It has been a year since I've done these,  so I'm a bit foggy on the
details, but you should be able to google session tables versus global
temp tables in DB2 to get more information about how to add an index to
each one; I know that it's possible to add an index on the fly to a
session table. 
 
-Mary
====================
This email/fax message is for the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution of this
email/fax is prohibited. If you are not the intended recipient, please
destroy all paper and electronic copies of the original message.