Netezza Generate External Command

NetezzaGenerateExternal

CREATE EXTERNAL TABLE 'path/to/flat/file.dat'
USING ( delim ',' datestyle 'YMD' datedelim '-' REMOTESOURCE 'ODBC'  requireQuotes true quotedvalue 'yes' LOGDIR 'path/to/log/directory/' nullvalue '')  AS
SELECT *
FROM MonkeyPants

NetezzaLoadExternal

INSERT INTO target_table SELECT * FROM EXTERNAL 'C:\FileName.txt'
using( delim '|' datestyle 'MDY' datedelim '/' REMOTESOURCE 'ODBC' MAXERRORS 50
LOGDIR 'C:\');