The Netezza Community: How to specify non-printable delimeter

Skip navigation

Netezza.comThinking.Netezza.comBookmark This Site

Up to Discussions in Enzee Universe

22339 Views 5 Replies Latest reply: Mar 4, 2010 7:37 PM by bmasna

Mark Aukeman

26 posts since
Oct 14, 2008

Currently Being Moderated

Oct 25, 2009 10:20 AM

How to specify non-printable delimeter

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!

Like (0)

Tags: nzload, external_table

David Shuttleworth
270 posts since
May 14, 2008

Currently Being Moderated

1. Oct 25, 2009 11:25 AM (in response to Mark Aukeman)
Re: How to specify non-printable delimeter

Have a look at this recent thread which also discusses this issue :

http://www.enzeecommunity.com/message/3303#3303

Report Abuse

Like (0)
Mark Aukeman
26 posts since
Oct 14, 2008

Currently Being Moderated

2. Oct 25, 2009 12:03 PM (in response to David Shuttleworth)
Re: How to specify non-printable delimeter

The link does not work -- unauthorized. Can you give me the group and message header. I will try to search for it. Thanks!

Report Abuse

Like (0)
David Shuttleworth
270 posts since
May 14, 2008

Currently Being Moderated

3. Oct 25, 2009 12:09 PM (in response to Mark Aukeman)
Re: How to specify non-printable delimeter

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.

Report Abuse

Like (0)
Shawn Fox
1,333 posts since
Aug 15, 2006

Currently Being Moderated

4. Oct 28, 2009 11:25 AM (in response to David Shuttleworth)
Re: How to specify non-printable delimeter

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/

Report Abuse

Like (0)
bmasna
12 posts since
Mar 6, 2009

Currently Being Moderated

5. Mar 4, 2010 7:37 PM (in response to Mark Aukeman)
Re: How to specify non-printable delimeter

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.

Report Abuse

Like (0)

Go to original post

Legend

Correct Answers - 4 points
Helpful Answers - 2 points

Oct 25, 2009 10:20 AM

How to specify non-printable delimeter

Actions

More Like This

Bookmarked By (0)

Legend