Re: insertion through dbi

2006-04-11 Thread Tom Schindl
Baserdem, Mehmet wrote: Hi all, I am trying to insert 16K records into some table through DBI. But my script only inserts the last record. I check the array size and the sql return values. Everything seems normal. Any ideas? Regards, Mehmet Baserdem Here is the my script:

RE: insertion through dbi

2006-04-11 Thread Baserdem, Mehmet
Hi all, I guess I found the source of the problem. The new line chars at the end was preventing the insertion at middle rows. Below code works fine. Regards, Mehmet Baserdem #!/usr/bin/perl use DBI; use DBD::DB2::Constants; use DBD::DB2; @IDS =(); # open file open(FILE, data.txt)