Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Need help with Unload/Load from/to a table

2 posts in Windows NT Last posting was on 2000-06-28 10:15:57.0Z
Sandy Suriyakumar Posted on 2000-06-28 03:47:48.0Z
Message-ID: <39597564.C0BC894D@nortelnetworks.com>
Date: Tue, 27 Jun 2000 23:47:48 -0400
From: Sandy Suriyakumar <suriyaku@nortelnetworks.com>
Organization: Nortel Networks
X-Mailer: Mozilla 4.72 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Need help with Unload/Load from/to a table
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 7
NNTP-Posting-Host: 47.248.129.229
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1966
Article PK: 1089401

Hi,

I am new to Sybase. I need help to unload data from a table to a file
and load the data from a file to a table in Sybase. Anyone out there
know how to do that? can I use bcp utility to unload/load data. What is
the syntax?

Thanks in advance.

Sandy


Andy Price Posted on 2000-06-28 10:15:57.0Z
From: "Andy Price" <andy.price@canada.com>
References: <39597564.C0BC894D@nortelnetworks.com>
Subject: Re: Need help with Unload/Load from/to a table
Date: Wed, 28 Jun 2000 11:15:57 +0100
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <16cyLsO4$GA.86@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: dyn240-ras13.screaming.net 212.49.236.240
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1965
Article PK: 1089399

syntax:
bcp database.owner.table direction(in/out)
filename -Uusername -Ppassword -Sserver -c

example:
bcp master..syslogins out syslogins.dat -Usa -Pjupiter -Sparis -c


--
Andy Price
Sybase Certified Adaptive Server Administrator - Associate v11.5

"Sandy Suriyakumar" <suriyaku@nortelnetworks.com> wrote in message
news:39597564.C0BC894D@nortelnetworks.com...
> Hi,
>
> I am new to Sybase. I need help to unload data from a table to a file
> and load the data from a file to a table in Sybase. Anyone out there
> know how to do that? can I use bcp utility to unload/load data. What is
> the syntax?
>
> Thanks in advance.
>
> Sandy
>
>