Stephane Legault [[EMAIL PROTECTED]] wrote:
> I use Perl to connect to DB since a long time but my needed until now was
> just make a select and insert!! Now I want to update a specific row (in
> fact the first row) in a simple table. I use a DB2 database. Can someone
> help me?
This isn't a DBI question - it's really an SQL question, and
therefore should be asked on an SQL mailing list.
Here's something that may get you started - I *don't* know if
it will work with DB2, as I've never used DB2.
my $sql = qq{
UPDATE my_table
SET column_to_update = ?
WHERE some_column = ?
};
If you're not familiar with placeholders(?), read the DBI
perldocs by doing "perldoc DBI" at a command prompt. This
example assumes that some_column is a column whose value
you know, and can be used to uniquely identify the row you
want to update.
HTH.
--
Hardy Merrill
Senior Software Engineer
Red Hat, Inc.
