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.

Load data

2 posts in Windows NT Last posting was on 2000-08-02 07:37:03.0Z
Fabrizio Posted on 2000-08-01 06:48:22.0Z
From: "Fabrizio" <fmarenzoni@mclink.it>
Subject: Load data
Date: Tue, 1 Aug 2000 08:48:22 +0200
Lines: 7
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: <bpPilX4#$GA.90@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: web.minlavoro.it 195.94.132.2
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1796
Article PK: 1089267

Hi,
How can load data from .dfb or .txt into sybase table?
I use adaptive server 11.9.2.

Thanks.


"Mark A. Parsons" <pegasys Posted on 2000-08-02 07:37:03.0Z
Message-ID: <3987CF9E.23369965@_internet.co.nz>
Date: Wed, 02 Aug 2000 19:37:03 +1200
From: "Mark A. Parsons" <pegasys@_internet.co.nz>
Organization: Pegasys (2000) Limited
X-Mailer: Mozilla 4.72 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Load data
References: <bpPilX4#$GA.90@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 18
NNTP-Posting-Host: p493.ipa1-n8-16.iconz.net.nz 210.48.25.237
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1791
Article PK: 1089261


Fabrizio wrote:

> Hi,
> How can load data from .dfb or .txt into sybase table?
> I use adaptive server 11.9.2.

If you can get your data into a delimited ascii/text file ... or fixed
format file ... you can use the 'bcp' utility. This is an OS utility
that Sybase supplies for allowing you to 'b'ulk 'c'o'p'y data in/out of
the dataserver.

Check the Sybase manuals for your particular OS platform ... you're
looking for a book called "Sybase <OS> Utilities". This book will
contain info about the startserver, dataserver, backupserver, bcp, isql,
defncopy, etc., commands.
--
Mark A. Parsons

Iron Horse, Inc. iron_horse@compuserve.com
Pegasys (200), Ltd pegasys@internet.co.nz