Answer

You can copy a table from one database to another database in either of the following ways:

• Using nzsql to extract the data and nzload to load data
• Using external tables to copy a database table

nzsql -db <database> -u <user> -pw <password> -A -t -c "select * from <table>" -o <file>

• The -A option specifies that the data is not aligned by whitespace characters but rather aligned in table output mode
• The -t option specifies that NPS outputs rows of data only; do not output column headers
• The -c option specifies that NPS runs the SQL enclosed in quotes as a single query
• The -o option specifies that NPS sends query results to a file

nzload -db <database> -pw <password> -t <table> -df <datafile> -delim '|'

create external table table_external sameas

using (dataobject ('/home/nz/outputfile.data')

delimiter '|');

nzsql -db <database> -u <username> -pw <password> -c "insert into table_external
select * from <table>"

nzsql -db <database> -u <username> -pw <password> -c "insert into <table> example select *
from example_extern"

CREATE TABLE <table> as select * from <source_database>..<source_table>;