When doing selects using bcp format (-m bcp) with SQSH is...

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by Tapón
Submitted on 4/1/2004
Related FAQ: Sybase FAQ: 9/19 - ASE Admin (6 of 7)
Rating: Not yet rated	Rate this question:
When doing selects using bcp format (-m bcp) with SQSH is there a way to suppress the output of the final column separator ? If you select 3 columns in BCP format, sqsh terminates each of the columns with the column separator. I only want separators BETWEEN columns (for BCP), I don't want an extra one at the end of the line.

Answer by Doug
Submitted on 7/20/2006
Rating: Not yet rated	Rate this answer:
You can set the row separator character to be blank like this: sqsh -L bcp_rowsep=""

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: