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?