Need help- to read each line of CSV File

[muralimk05]

I have to read each line from a CSV file and insert same data into a DB2 Table" number of lines in CSV may be 100000 or 10000"

if any of you having the script please send me. Thanks in Advance.

muralimk05@gmail.com

 

[stevexff]

Use the module Text::CSV_XS. It will make light work of reading your CSV file. The number of lines in the file is irrelevant, although you might want to take a syncpoint periodically to protect DB2 from a massive rollback if your script falls over...

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]