topic SQL - DB2 - Pass-Thru-Retain table across queries in SAS Procedures

SQL - DB2 - Pass-Thru-Retain table across queries

deleted_user — Wed, 16 Jul 2008 13:43:39 GMT

I want to pull a subset of a db2 query and place in a sas dataset. Then run a second query against that output and some other db2 tables. I consistantly get the message in the second query that the sas dataset is a 'undefined file'.
I've been told by unreliable sources that I CAN'T reference a sas dataset in subsequent queries because the FROM statement in Pass-Thru doesn't 'know' about sas.....is this true? if so, any idea of how I can create a 'hold' space of my own in db2 to store my data in a table (rather than a sas dataset) for use across queries?

Re: SQL - DB2 - Pass-Thru-Retain table across queries

darrylovia — Wed, 16 Jul 2008 16:29:26 GMT

You could store the query in a DB2 temporary table. See the SAS/ACCESS documention on temporary table support for DB2.

We have Oracle where I am and I use temporary table feature occationally.

-Darryl

Re: SQL - DB2 - Pass-Thru-Retain table across queries

deleted_user — Thu, 17 Jul 2008 00:05:55 GMT

Thank you, unfortunately i get a security access error saying I'm not allowed to create a table....(sigh)...thanks much anyway...

Re: SQL - DB2 - Pass-Thru-Retain table across queries

MattC — Wed, 23 Jul 2008 19:38:50 GMT

Check with your DBA to see if they have a separate schema on your database that allows temporary tables from users.