Error with executing a copy command on a ascii 29 delimited file

Prasanna_1

Hi All,

I am getting this error executing the copy command in VSQL commandline below. Please let me know your thoughts.Thanks

copy sample.temp_full from local 'test.txt' delimiter E'\029'.

ERROR 2730. COPY delimiter must be a single character

Prasanna_1

the ascii delimiter I am referring to is Group Separator aka GS

Prasanna_1

My apologies! I was using the wrong delimiter type. 

I am using the following command now and it works fine: copy sample.temp_full from local 'test.txt' delimiter E'\035'

Bhawana

Hi Prasanna,

I am glad it worked out well.

Regards,

Bhawana