Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Athey, Keith" <Keith dot Athey at twc dot state dot tx dot us>
Subject: RE: help with inserting text
Date: Feb 18 1998 3:06PM

My suggestion would be to use BCP.  It'll be faster and its supported by

> -----Original Message-----
> From:	philip mikal []
> Sent:	Tuesday, February 17, 1998 8:44 PM
> To:
> Subject:	help with inserting text
> Hello:
> I am a bit confused on how one inserts text into Sybase using DBlib. I
> have 
> data that I am trying to load into my database that looks like:
> µ-ziq|24|129||"America'
> s premiere
>  electronic label, Astralwerks Records, presents the
> µ-ziq"|astralwerks@car
> I am taking this data from a text file, spliting it apart (pipe
> delimited, "|")
> into variables and attempting to insert it into my database.  All my
> columns 
> are text datatypes except for two, integers, which in the above
> example, would 
> be "24" and "129".
> I believe I am to use dbwritetext, but I do not understand it
> properly. The 
> examples in the man pages are confusing to me, e.g., how does one
> determine 
> the column number.
> If anyone could explain how to accomplish this, it would be greatly 
> appreciated.
> Regards,
> Philip