PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Rob Truban <rtruban at erols dot com>
Subject: Insert Record
Date: Jan 27 1998 9:20PM

Greeting All,

Could someone please post an example of how to do an insert command.  I
tried something like this
with no luck.

#!/apps/perl/perl5/perl


use Sybase::DBlib;

use Getopt::Long;


$dbh = new Sybase::DBlib $User, $Password, $server;


$dbh->dbcmd("insert myTable
values (23561, 2020, 0, "Some text", 0, "NULL", 1, 26643, 1102, "Why
me?",
"Feb 4 1998 3:55PM", "MDB", "Hello", 0)");


$dbh->dbsqlexec;

$dbh->dbresults;




I know this is beginner's stuff, I apologize...  I just want to insert a
record on the fly, nothing  fancy.

Thanks In Advance

Rob Truban