Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Generating a Format File in Sybase ASE BCP
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?
Asked:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
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.