Help using Base SAS procedures

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

Reply
N/A
Posts: 0

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

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?
Frequent Contributor
Posts: 139

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

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
N/A
Posts: 0

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

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

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

Check with your DBA to see if they have a separate schema on your database that allows temporary tables from users.
Ask a Question
Discussion stats
  • 3 replies
  • 112 views
  • 0 likes
  • 3 in conversation