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

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 ...