In oracle, we can use the 'spool' command to output the data in the database to the local drive.
In netezza, there is a nzsql command that can do this. But it seems nzsql can not be used on windows.
From the following link:
http://stackoverflow.com/questions/16396204/can-i-export-the-sql-query-results-from-netezza
We can see that, we can use Workbench Command Line Builder to do this:
menu option Tools -> Workbench Command Line Builder
Here is a very detailed explanation:
https://support.aginity.com/hc/en-us/articles/214809698-Batch-Processing-With-Workbench-
I wrote about the solutions to some problems I found from programming and data analytics. They may help you on your work. Thank you.
ezoic
Subscribe to:
Post Comments (Atom)
looking for a man
I am a mid aged woman. I live in southern california. I was born in 1980. I do not have any kid. no compliacted dating. I am looking for ...
-
I tried to commit script to bitbucket using sourcetree. I first cloned from bitbucket using SSH, and I got an error, "authentication ...
-
https://github.com/boto/boto3/issues/134 import boto3 import botocore client = boto3.client('s3') result = client.list_obje...
-
There are some fun tools on Mac/PC which can help you on your studies, life and research. 1. Evernote: https://evernote.com/ To downl...
No comments:
Post a Comment