Question & Answer
Question
How do I spool results to an output file using nzsql?
Answer
It is common practice to use nzsql to spool query results into a regular file using either of these commands:
nzsql -d <database> -u <user> -pw <passwd> -A -t -c "<query>" -o <file>
nzsql -d <database> -u <user> -pw <passwd> -A -t -f query.sql -o <file>
This will work most of the time but there is a limitation: If the selected output file grows over 2GB, nzsql will fail with error message
Error: file too large.
To avoid this limitation, spool the results of your query to an external table, using this syntax:
CREATE EXTERNAL TABLE [table_name] 'filename'
[USING external_table_options]
AS select_clause
Historical Number
NZ433383
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21567479