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:
TEXT_EXTTXT.ID_TEXT = TEXT_PERM_USR.ID_TEXT