Re: Output results from SQL SELECT into a table

You've got to put the "with" where the select goes. Here's an example

create table qtemp/Customers as
(
with mycust as
(
select strip(city) || ', '
|| state || ' '
|| zipcod as Last_Line,
a.*
from QIWS/QCUSTCDT a
)
select * from mycust
) with data



Sam

On 3/26/2012 4:24 PM, Buzz Fenner wrote:

I'm really digging being able to assemble multiple WITH/AS clauses with a
SELECT statement to return results in an interactive SQL session, but I'm
being asked to populate a table with the results. Short of using my debugged
SQL code in an RPG program to write the output (can I even do that?) to a
file, is there an easy and/or elegant way to do what I need?

From what I'm gleaning from the SQL manual, it doesn't seem that SELECT

output can be directed to a file.



Buzz Fenner

Business Systems Analyst/Systems Administrator

City Water& Light

870.930.3374 | 870.219.5229

bfenner@xxxxxxxxxxxxxxxx