Need to do 2 steps to unload data from your database into a file:

1. Create an external table that uses column definitions from an existing table:

CREATE EXTERNAL TABLE demo_ext SAMEAS emp USING (dataobject

('/tmp/demo.out') DELIMITER '|');

2.Unload data from your database into a file by using an insert statement:

INSERT INTO demo_ext SELECT * FROM emp;

For more detail see "CREATE EXTERNAL TABLE" in documentation.

Errors from your nzsql command should print on the screen as you haven't re-directed the SYSERROR to a file.

example:

nzsql -a -E  -f /usr/abc.sql > /usr/abc.log 2>&1

above statement will capture the errors in log itself when these processes are run in the background.

when you are running the script in db, you can spool the output using \o <file name> on the nzsql prompt.

This is not quite accurate.  A remote external table can be used from an ODBC- or JDBC-connected client to create an flat file local to the client system with the REMOTESOURCE option. Remote external tables cannot be used with nzsql, since the underlying connection is not ODBC.

For example, with Aginity Workbench on my Windows 7 laptop connected to to TwinFin3 I ran the following:

drop table pass;

create table pass (

username varchar(64) not null,

password char(8),

userid bigint not null,

groupid bigint not null,

fullname varchar(255),

homeDir varchar(255),

shell varchar(255)  )

distribute on random;

insert into pass (select * FROM EXTERNAL '/etc/passwd' using (DELIM ':' TIMEDELIM '-'))

limit 28 ;

CREATE EXTERNAL TABLE 'C:\Users\IBM_ADMIN\Documents\tmp\0928\localpass.txt'

  using (DELIM '|' REMOTESOURCE 'ODBC') as select * from pass;

The result is a file called localpass.txt on my laptop.