ISQL-SE 4.10.DD6 (DOS 6.22): BCHECK C-ISAM B-tree Checker version 4.10.DD6 C-ISAM File: c:\dbfiles.dbs\*.* ERROR: cannot open C-ISAM file In SE2.10 it worked with wilcards * .* for all files, but in SE4.10 it doesn’t. I have an SQL script which my users periodically run to reorg customer and transactions tables. Then I have a FIX...
I have a pawnshop CRUD app written 20 years ago with INFORMIX-SQL/SE (DOS) which is currently running on DOS 6.22 within Microsoft Virtual PC 2007 on Windows Vista. I would like to modernize this app with a GUI, SQL-based engine and retain its existing functionality. It doesn't require any networking or multi-user capability. I would pre...
I have a structure of about 10 tables. This structure works great for data entry. However, I also need to preform complex and fast searches on that dataset. There are three approaches to this I can think of: Join all those tables in select. This is pretty slow and likely not a good approach. If it's relevant, database is Informix; I've...
I'm debating whether to re-write my INFORMIX-SQL app with I4GL (character-based) or another Windows/GUI-based tool. I want to know specific instances of limitations, bugs or drawbacks of using another development tool before I invest considerable amount of time evaling another product. Answers to this question could save me a lot of tim...
I recently downloaded Visual Studio 2010 and would like to know if this multi-paradigm programming language is the right language for what I what I want to accomplish.. I don't have any experience with OOP, rather I'm an ole school procedural language programmer. I also downloaded an eval version of RADvolution Designer. My goal is to co...
I’m having a problem with a linked Informix table in MS SQL Server 2008r2. When I query this table, it seems to ignore some of the criteria I’m passing to it but not others. For example if I put a condition on the rowdate field the remote query part of the execution plan does not show any WHERE clause but if I put criteria on another fie...
ISQL-SE 4.10.DD6 (DOS 6.22): My app has the following SQL script (CODE REVIEW) which my users exec at end of business day to reorg the transaction table: DATABASE dbfiles; UNLOAD TO "U:\UNL\ACTIVES.UNL" SELECT * FROM transaction WHERE trx_type IN ("E","I","C","P") ORDER BY trx_cust_fullname, trx_last_pymt; UNLOAD TO...
Hi. Say I have a table on an Informix DB: create table password_audit ( username CHAR(20), old_password CHAR(20), new_password CHAR(20), update_date DATETIME YEAR TO FRACTION)); I need the update_date field to be in milliseconds (or seconds maybe - same question applies) because there will be multiple updates of the pa...
Does anyone know if Informix has the same capability as Oracle with respect to the autoextend feature. With Oracle I can create a datafile and by using the autoextend feature Oracle will automatically grow the file when it gets full. Does Informix have anything like that for chunks? I can't seem to find anything in the documentation. T...
Server Information Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001 Server: Informix Dynamic Server Version 7.31.UD3 Information: Link: http://stackoverflow.com/questions/192477/connecting-to-informix-database-from-net Article: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0510durity/ I am running Vi...
INFORMIX-SE: My users periodically run an SQL script [REORG.SQL] which unloads all rows from a table in sorted order to two separate files (actives and inactives), drops the table, re-creates the table, loads the sorted loadfiles back into it, creates a cluster index on the same column I sorted my unload files by, creates other supporti...
Example: I have a file: FILENAME.EXT and would like to extract FILENAME without the .EXT I want to be able to use the extensionless filename for a command which only accepts filenames without its extensions. I have a utility called BCHECK which accepts as its argument a filename with no extensions. Using BCHECK *. does not work because a...
INFORMIX-SE (multi-user versions): Can I start SE in maintenance (standalone mode) where the DBA is the only user who can access the engine, then change its mode so that all users can access it? (This is analogous to booting Unix in single-user mode and then going multi-user. Oracle provides this functionality.) ...
OK, so I recently downloaded 4J's Genero Studio 90-day trial version. I would like to use INFORMIX-SE for the backend with Genero's client. Is INFORMIX-SE for Windows available on a trial version?.. I see that IDS is available as a free download, but IDS would be an overkill for my app. ...
INFORMIX-SE 7.1: Assume that col5 CHAR(5) will only contain numbers from 00001 to 99999: a CHAR(5) column uses 5 bytes of storage, how many bytes does an INTEGER use? Does a UNIQUE INDEX on an INT column perform faster than a CHAR(5)? Is SELECT MAX() on an INT column faster than MAX() on the col5 CHAR(5)? ...
I have an app where depending on the type of transaction being added or updated, the ticket number may or may not increment. I can't use a SERIAL datatype for ticket number because it would increment regardless of the transaction type, so I defined ticket number as an INT. So in a multi-user environment if user A is adding or updating a ...
Thirty years ago, when I began to design and develop CRUD business applications, I envisioned that as time moved on, designing, prototyping and customizing business applications would become easier and more streamlined. In 1983, I discovered a simple, easy-to-use RDBMS called INFORMIX which enabled me to quickly define schemas, generate ...
I have a program that reads about a million of rows and group the rows; the client computer is not stressed at all, no more than 5% cpu usage and the network card is used at about 10% or less. If in the same client machine I run four copies of the program the use grow at the same rate, with the four programs running, I get about 20% cpu...
Questions 1 and 2 are specific to INFORMIX-SQL 4.10.DD6 (DOS) Perform screens. Question 3 applies to any version of INFORMIX-SQL in any environment. I would like to be able to display more than 80 columns on my perform screens to fit more stuff in one page. I tried DOS 6.22 command ‘MODE CON: CO132’ and on my perform screen I specified...
Assuming compilers and runners are from same versions, can they be executed on any platform (i.e. UNIX, LINUX, WINDOWS, DOS, etc.) without the need to re-compile the source code? ...