Perl Data structure help

[mk58581]

Hi

Am lookin' for an example script to extract similar set of data from 3 different servers (Sybase/Oracle/MS SQL) and perform say sum for one of the columns.

Which reference is best in extracting the rows.

It would of great help if anyone of you could suggest me a gud book for references, array of arrays, hashes of hashes

Thanks in advance

 

[mk58581]

As well if there a comma separated file from which i have to access the values and use them while performing arithmetic operation for the above.

Thanks

 

[stevexff]

SQL servers like the ones you describe above support standard SQL functions to sum columns. Do the work in the SQL, not in your code, then it will be portable in the way you want, and you will only have to change the connection string for the DBM.

See the DBI module on CPAN for database access, and the very useful site

http://www.connectionstrings.com

for how to connect to a whole variety of DBMs.

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]