Sanj
Reputation: 13
extract netezza table records to linux local file system
Would like to extract Netezza table data to local box ? So is there any native adapter or tools available ( Like TPT in Teradata) which can be implemented and extract records from Netezza ? If not what would be the best solution to do so. Please suggest.
Upvotes: 0
Views: 132
Answers (1)
Lars G Olsen
Reputation: 1118
Have you looked at the ‘create external table as select ... from ...’ syntax. It has a ODBC or JDBC possibility that should make this possible.
Upvotes: 1
Related Questions
- Netezza import from external file error: Unsupported external table reference, unable to derive shape
- In netezza aginity how to get the structure of the table
- Netezza Loading table from SQL Server
- Load Table in SAS to Netezza
- Netezza CSV load
- Netezza : Fetch all database names and write to a file in unix directory
- Is it possible to bulk load textfile into Table instead for External Table in Netezza?
- Export specific query data to CSV file from netezza database
- Copy huge data from Netezza to Teradata
- Netezza: how to save select results