to create format file for bcp in

UNIX for Advanced & Expert Users
1

I want to create the format file for bcp in a file to the table.
My Versions are:
Unix: Sun OS,
DB: Sybase.

How can i create the format file.
Is there any way to create the format by bcp command
or some system sp.

Please help.

2

Hi all ,

i have tried this command
bcp db..tablename out outpath/outfile.txt -f formatpath/formatfile.FMT -N -Uuser -Sserver -Ppass

I got the below error:

bcp: Unable to open format-file "formatpath/formatfile.FMT "

Then i created a file "formatfile.FMT" in the formatpath and then tried the same command

getting the different error:

I/O error while reading bcp format-file.

Please help me.

3

For that IO Error,
i checked the file system, enough space is available.
till i am getting the same error.

Please help me.

4

prasad,

Try with .dat file with -C tag

bcp db..sample out act.dat -SSERVER -UUSER -PPWS -c -t~

it might wroks. Revert me if you have faced any issues on this.