I need some advice on how to get results of a query to dump/export to a CSV file at a specified path/location.

The issue is when I run the query in TOAD for DB2 or DB2 Control Center a memory error is thrown because the server configuration parameter, applhpsz, is set to 4096. I can not increse the parameter value so I am looking for a work around script/procedure to run that won't throw the error and can be automated.

Here is the query:

SELECT
TEXT_EXTTXT.ID_TEXT,
TEXT_PERM_USR.PUBLICATION_DATE,
TEXT_EXTTXT.CLOB_OBJECT,
TEXT_PERM_USR.HEADLINE,
TEXT_PERM_USR.BYLINE,
TEXT_PERM_USR.SOURCE,
TEXT_PERM_USR.SECTION,
TEXT_PERM_USR.PAGE,
TEXT_PERM_USR.EDITION
FROM
nica.TEXT_PERM_USR,
nica.TEXT_EXTTXT
WHERE
TEXT_EXTTXT.ID_TEXT = TEXT_PERM_USR.ID_TEXT

Thanks for any help!!!
Matthew

That is the same value that we are using and we throw far more complex SQL at the server. What is the DB2 version and OS? What is the DDL for both tables?
What is the exact error you are getting?

Andy