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")

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

insertion through dbi

2006-04-11 Thread Baserdem, Mehmet
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: #!/usr/bin/perl use DBI; use DBD::DB2