OK first of all, I'm a total perl newbie. I've been programming in VB for a
couple years, but I'm "gradutating" into perl. May god have mercy on us all.
My question is more conceptual:
I have two comma delimited text files, that are essentially database tables.
One is materials, one is orders.
They link via material field in a one to many relationship. (Material)
My goal is to have all pertinent information from these tables linked and
loaded as demand into an array/hash (I'm new, but it's looking like it will
be a hash) and then additional manipulations/comparisons will be done with a
third file.
The two tables lend themselves very naturally to a SQL statement.
Does PERL support SQL without a specific database/driver installed? I've
scanned through the DBI in CPAN but I couldn't find an answer. (Again, I'm a
newbie)
If not, what is an optimal approach to this problem?
My first hunch would be to loop through the demand file one record at a
time, link the data from the materials file, and load into a hash. Both
files will have approximately 6000 records. (+/- 2000)
Any help would be appreciated.
