Doing a SQL Pass-thru on Netezza, trying to do a prepare, something like this:

SQL SQLNEZ PREPARE SQLOUT FOR (
SELECT * FROM tname
)
END
TABLE FILE SQLOUT
PRINT *
END

I can do it in SQL Server but Netezza does not seem to support it. Anybody got an idea?

Linux RedHat, WF 8.0.06
Tia
Håkan

This message has been edited. Last edited by: <Kathryn Henning>,

Hi Håkan,

Try this -

SQL SQLNEZ PREPARE SQLOUT FOR
SELECT * FROM tname
;
TABLE FILE SQLOUT
PRINT *
END

T

Tony, it was about there I started, and having tried a few variants.

Either I get EDA no data or some error message from Netezza. Give it a try yourself on our box (yes, I'm at Arcadia for the moment)

/H

The following SQL passthrough, to Netezza, returns the expected data for me:

ENGINE SQLNEZ SET DEFAULT_CONNECTION mycon
END
ENGINE SQLNEZ
select *
from mytable
;
-*
TABLE FILE SQLOUT
PRINT *
END
-RUN  

David, that works fine, but the idea is being able to retrieve the rows and apply e.g. a DEFINE on SQLOUT, without having to produce an intermediate file.

Hi Håkan,

Yes, I know where you are currently .

Your first post didn't give the impression that you wanted DEFINEs to be passed to NETEZZA, just SQL passthru.

If I get a chance tomorrow - and no-one else has given you an answer - I'll see what I can churn out for you and send you some samples.

T