in reply to Re: updating records into RDBMS from a text file
in thread updating records into RDBMS from a text file

Sorry for being too cryptic! Till now what I have done is:
I am reading the delimited text file and am taking each line into an array
I have constructed the SQL statement (Update table..) and again put it into an array
as the Update statements will have to be executed one at a time right? What I would like help on is the interaction with the RDBMS like
opening database connection and then actually executing the Update commands that I have constructed put into the array
I can't use the RDBMS utilities to read the text file but I want the external utility (that I am building) to do it.
Thanks once again!
Joe
  • Comment on Re: Re: updating records into RDBMS from a text file

Replies are listed 'Best First'.
Re: updating records into RDBMS from a text file
by Abigail (Deacon) on Jul 13, 2001 at 14:36 UTC
    Well, it looks like you have no experience with connecting to a database from without Perl. Luckely, there are various modules that do a lot of work for you. You should check out the DBI module, and a DBD driver for the RDBMS you work with. DBI is a generic interface, giving the same interface to many different database servers. There are also packages for specific databases, which will give you more features - but you lose in portability. Take your pick ;-)

    -- Abigail

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom