ezoic

Wednesday, October 26, 2016

Things in Netezza similar to spool in Oracle

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-

No comments:

Post a Comment

R is not a simple programming language, and it does better on reading excel files than python

R is not a simple programming language, and it does better on reading excel files than python . tried to read excel files to python and R. i...