Re: SQL.IEM file and table name case

blah@blah.com (Blah) wrote: :I have a custom application that is trying to create a table using the BDE in :WInNT. And what is BDE? : I'm running Informix Dynamic Online Server 7.22. When the app is :trying to create the table a SQL -461 error Finderr on Windows NT (and Unix) says: -461 File open error. This statement transfers a value between a file and a BYTE or TEXT column. Since the locator structure field loc_loctype was set to LOCFNAME, the database server tried to open the file using the pathname in loc_fname and the flags in loc_oflags. An operating-system error was returned. Check the accompanying ISAM error code for more information, and look for operating-system messages. Typical causes include lack of disk space, file permission problems, and limits on the number of open files. : is returned on the file SQL.IEM. So they have probably used the 461 error code for something other than the error message says. If this name is shown somehow it probably mean the file couldn't be found. This file contains the textual description of the error messages generated by the engine. :All the SQL.IEM files have Full Permisions on the network. All? There should be only one SQL.IEM file, and it should be located in some subdirectory below the msg subdirectory in your INFORMIXDIR directory. Have you set the INFORMIXDIR variable (in setnet32)? : There is around :700MB free on the drive. The user attempting to create the table has DBA :permissions. How much freespace there is on the drive isn't interesting when you create a table (or otherwise use space in a database). It's how much freespace there is in the database itself. That's all located inside the file(s) that contains each chunck. On Unix that's easily checked by a menu selection in onmonitor. I don't know how to do it on NT. The new ROM (Relational Object Manager) don't seem to be able to show such things (other than probably via some cludgy sql using the sysmaster database). You should be able to use the onstat or some other command line utility to find it (I don't use those if it can at all be avoided). :Any idea what may be causing this? If your INFORMIXDIR variable isn't set appropriately any number of errors can occur. : What is the SQL.IEM file? See above. : Does Informix :support upper case or mixed case table names? Table names are case insensitive in Informix. I haven't ever tried anything but lowercase table names so I don't know if it preserve case or whatever it does. :Thanks. : :Craig : :craigm@goldminesw.com Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org