Export Data with BELL character delimiter

Dear Lister - Im trying to export data into .del files with BELL character delimiter.

not sure correct syntax for " BELL character delimiter" current using '\u007'.. which is now working.

vsql -U dbadmin -F '\u0007' -A -o /home/dbadmin/cnp_prime_opportunity_1_1a.del -c "select * from dburmist.cnp_prime_opportunity_1_1a;";

Could you please some one tell me what is the right syntax to extract data with "BELL character delimiter".

Much appreciate for your response. Thanks

-arathinas

Hi All..

I got the answer for this question..

vsql -U dbadmin -w vrtdba -F $'\7' -A -o /home/dbadmin/cnp_prime_opportunity_1_1a.del -c "select * from dburmist.cnp_prime_opportunity_1_1a ;";

Sign up