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 was born in 1980. I do not have any kid. no complicated dating before . I am looking for a man here for marriage...
-
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...
-
Previously, I wanted to install "script" on Atom to run PHP. And there was some problem, like the firewall. So I tried atom-runner...
No comments:
Post a Comment