Hello! I use the WITH statement in DB2 pass-thru sql to create a series temporary tables in order to get all the data I need for my pass-thru join. These tables are deleted when the query closes and are therefore not traditional temporary tables where I create from the SAS side and load with data from SAS. This query needs to be converted to Oracle as they are swapping out their old DB2 database. What is the equivalent Oracle syntax for the WITH statement in order to make a series of tables within my pass-through query that I can all join together while still in-database? I attached a sample of the code that I wrote for DB2 that needs the Oracle equivalent syntax. Thank you!! michael
... View more