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

[deleted_user]

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?

[darrylovia]

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

[deleted_user]

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

[MattC]

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