I would use a non-printable character as a delimiter for external table to avoid load errors. I tried (CTRL-SHIFT-‘_’) by entering directly (it displays as a box) but got an error saying the delimeter had to be a single, unsigned character. Any suggestions? Thanks!
Have a look at this recent thread which also discusses this issue :
The link does not work -- unauthorized. Can you give me the group and message header. I will try to search for it. Thanks!
It's in Netezza Community > Users > Discussions and the subject is
External Table with C-Cedilla Delimiter (Ç)
... or just search for 'delimiter' and you'll get several hits, some of them relevant to your question
D.
You can just specify the ASCII code number for the character instead of quoting the character.
create temp table testtable (x integer, y integer);
select *
from external 'c:\temp\testdata.csv' sameas testtable
using (remotesource 'odbc' delim 44);
In this case ASCII character 44 is a comma "," character.
ASCII table reference: http://www.asciitable.com/
did you get the resolution?
We normally use CHR(08) as delimiter for transferring data from Oracle to Netezza. As download and upload has same delimiter, did not see any issues.
