Re: problem w/ temp tables on PC INFORMIX

In article <474@rhlab.UUCP> bkuhn@rhlab.UUCP (bmk Bradley Kuhn) writes: > >We are running DOS INFORMIX-4GL V 1.10.06E on a 286 Librex notebook >running MS-DOS 5.0. We use the protected mode engine, and protected mode >applications. > > Much of our code uses temp tables ; Often we execute statements such as >the following : > >create temp table foo (s serial, x int, str char(20))>. >. >declare c_mumble cursor for > select int_val, str_val from another_tab> >foreach c_mumble into prg_var_int, prg_var_str > insert into foo values (0, prg_var_int, prg_var_str) >end foreach>. >. >. >. >drop table foo> > >This code works fine, if we only execute the sequence once per program >run. However, when we attempt to create the temp table again, using the same >sequence of code we get this error on the first insert attempt: > >Program stopped at [line of insert command] >SQL statement error number -242. >ISAM error number -9.>Could not open database table (foo) > >We cannot understand why it cannot open the table, since the program just >created it a few lines before. Obviously, it has something to do with >dropping then creating it again, but we can figure out why. The code works >perfectly on INFORMIX-4GL V 4.00 running on our AT&T 3B2/600 under >AT&T UNIX SYS V R3.2.3. > >We attempted to remedy the problem by using a permenant table instead of >a temp table. This executes better (i.e. we can drop and re-create more than >once), but after about 4 drops and recreates it complete corrupts the database, >so that it must be deleted and re-created. > > Has anyone had any problems of this nature with the PC version? > >Any help will be appreciated. >Post to comp.databases.informix or by EMAIL. > -- > > -- Brad Kuhn Computer Systems Development, Inc > INTERNET: rhlab!bkuhn@uunet.uu.net OR bkuhn@loyola.edu > UUCP: ...uunet!rhlab!bkuhn This is interesting I am having almost the same problem on ISQL 2.10 for DOS. I am also running DOS 5.0, but on a 25MGZ 386dx, but I am getting the sameerror on a permenant table. It seems to happen when I use the ISQL databasename -ur command. I can use the querylanguage within ISQL and look at the table fine. I have unloaded all of my data, droped the database rebuilt it, loaded all my databack and I still get the error. I have also gotten an error that says I need to run the dbupdate utility because my data is not compatible (can't remember the number and I have never owned a previous version), BTW I have been running this database for over a year without any problems, but they just appeared when I recently added my tenth table to it. So, I would appreciate an help too! Thanks -- Greg Porter | gporter@csus.edu California State University, Sacramento | ucdavis!csusac!porterg University Telecommunications Services (UTS) | -- All opinions are my own and not of my employer --