Tuesday, April 10, 2018

How to unload the data from Netezza to flat file


script to unload the data with specific delimiter  from Netezza database

nzsql -host <server_name> -u <username> -pw <password> -db <DBname>F 'delimiter' -A -t -c "select * from  <table_name>" -O  output_file_name.log 

No comments:

Post a Comment