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
Error with executing a copy command on a ascii 29 delimited file
the ascii delimiter I am referring to is Group Separator aka GS
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'
I am using the following command now and it works fine: copy sample.temp_full from local 'test.txt' delimiter E'\035'
Hi Prasanna,
I am glad it worked out well.
Regards,
Bhawana
I am glad it worked out well.
Regards,
Bhawana
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
