Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Solved
Generating a Format File in Sybase ASE BCP
Posted on 2013-10-22
I cannot figure out for the life of my how to generate a format file in a batch file in sybase. I use the following to create my bcp of data file:
bcp mytester.dbo.XTABLE out XTABLE.bcp -U sa -P mypass -T -n
I would think I could do like in sql server:
bcp mytester.dbo.XTABLE format XTABLE.bcp -U sa -P mypass -T -n
or
bcp mytester.dbo.XTABLE out XTABLE.bcp -U sa -P mypass -T -n -f XTABLE.fmt
but it doesnt seem to work. it seems the only way to do it is in the mode when it prompts me for all details, which is unacceptable for waht I want to do (many tables in a BAT file).
Anyone know how to pull this off?
bcp mytester.dbo.XTABLE out XTABLE.bcp -U sa -P mypass -T -n
I would think I could do like in sql server:
bcp mytester.dbo.XTABLE format XTABLE.bcp -U sa -P mypass -T -n
or
bcp mytester.dbo.XTABLE out XTABLE.bcp -U sa -P mypass -T -n -f XTABLE.fmt
but it doesnt seem to work. it seems the only way to do it is in the mode when it prompts me for all details, which is unacceptable for waht I want to do (many tables in a BAT file).
Anyone know how to pull this off?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
Active 7 days ago
That is how it works, sadly. If you want bcp to generate a format file for you, it does so interactively.
However the format file has a well documented structure and there's nothing stopping you from writing your own, programatically, in a batch file or script.
See the Utility Guide for ASE of your version, available for free from the Sybase site.
However the format file has a well documented structure and there's nothing stopping you from writing your own, programatically, in a batch file or script.
See the Utility Guide for ASE of your version, available for free from the Sybase site.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month13 days, 15 hours left to enroll
656 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.