Re: INSERT INTO Informix with Perl DBI

In article <885925585.259915778@dejanews.com>, 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? > >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 > >I know I can correct this problem by dropping and recreating the table, >but that isn't very effective nor good Database management. > If this is Standard Engine check your UNIX kernel parameter, usually FLCKREC. If Online check the LOCKS setting in ONCONFIG. Of course you could always lokc the table in exclusive mode first... >Thank you in advance. > >Regards, > >Michael Wendel > >-------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care