Probably not a good idea (you didn't hear it from me!) but the delimiter for an external file is stored in a system table.. and therefore it can be set 'manually' by something like:

update _t_external set delim = chr(xxx) where _t_external.relid = _t_object.objid and _t_object.objname = 'my_external_table';

Where xxx is the ascii value for your delimiter.

D.

You should be able to type it via the keyboard by holding down the Alt key while typing 0231 on the numeric keypad..

D.

Hi,

I am using a 4.6.6 NPS box.

When I created the external table with 'Ç' as delimiter, I am getting the error "ERROR:  Input is not UTF-8".

PFB the external table description

create external table ext_template_table sameas template_table
using ( DATAOBJECT ('/home/abc/inp_file.pipe') DELIMITER 'ç' );

Any pointers to mitigate this error?

Thanks

Sebastian