Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    1

    Talking Unanswered: Export Table Join to CSV

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •