Re: Re: updating records into RDBMS from a text file

[Anonymous Monk]

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

[Abigail]

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