Re: INSERT INTO Informix with Perl DBI

mwendel@marketguide.com writes: > When doing an INSERT INTO using Perl DBI is there a limit of the number of > rows that can be inserted at one time? Or a max of rows x columns you can > do INSERT INTO with a single cursor or subroutine? No. > I keep getting the following messages when I attempt to do updates to the > tables I orignially populated using INSERT INTO: > > SQL: -240: Could not delete a row. > ISAM: -134: ISAM error: no more locks Are you doing this inside a single transaction? If so, it could be your LOCKS parameter in your config file. I have never used SE, so I don't know how it applies there. -- 'yvind Gjerstad Systems dept Tollpost-Globe AS N-6301 'ndalsnes/Norway E-mail: ogj@it.tollpost.no Phone: +47 7122 6663 Fax: +47 7122 6694