The FAQ 1.5 - What's new
Hey World, The Informix FAQ 1.5 is now available for ftp from kcbbs.gen.nz. This posting describes: - What's new in this month's edition of the FAQ - How to get an entire copy of the FAQ - A copy of the FAQ's table of contents I'll only post the entire document every few months or so, because it causes too much grief to those on the mailing list. Regards, Kerry S ----------------------------------------------------------------------------- 0 FAQ Facts ------------ 0.1 What's new in this release of the FAQ? ------------------------------------------- I've renumbered sections 7 thru 10 to become 8 thru 11, so I could add section 7 "Connectivity Questions". NEW!: 2.5 The Informix User Group Mailing list 4.1.15 How can I dynamically change Report OPTIONs at runtime? - Pointer to Appendix J 4.2.4 Can I use ESQL with C++ under 6.0? 4.6 Informix-4GL for Windows 4.6.1 How can I get a UK Pound sign as my MONEY code? 7.2 I-Net is slow... Help! 8.3 Questions about NFS mounted databases 8.4 How can I run tbtape from a cron job? 8.5 Calculating extent sizes - Pointer to Appendix K 8.6 How can I list a table's dbspace? 11.6 Does Informix run under Linux? APPENDIX J Dynamically changing Report OPTIONs APPENDIX K Calculating extent sizes IMPROVED! 2.2 How do I join the list or unsubscribe? - Now redirects potential mailing list customers back to Walt, seeing as the move to vungtau.cerf.net seems to have died. 4.1.6.3 Undocumented math functions from SELECT - Finally remembered to add the hex() function. 6.1 What're some pointers for configuring Online? - Section 11, Number of locks, a statement along the lines of "run out of locks and everything gets courupted" has been a bit more qualified. 11.5 What is Informix-Link - Now mentions that I-Link is now free to those under a maintenance contract 0.2 How can I get the latest copy of the FAQ? ---------------------------------------------- 0.2.1 anonymous ftp -------------------- The latest version of this document can be retrieved via anonymous ftp. Get a copy of: informix.faq.Z and: informix.apx.Z from: kcbbs.gen.nz in the "informix" directory or: mathcs.emory.edu in "/pub/informix/faq" You can drop the .Z suffix if you want an unCOMPRESSed flat ASCII file. 0.2.2 World Wide Web --------------------- The HTML version of the FAQ (1.2 I think) is available on: URL http://cc1.kuleuven.ac.be/student/informix-faq.html . It may also be available at: http://www.visionware.co.uk/informix-faq.html. 0.2.3 comp.databases.informix ------------------------------ I post the FAQ to c.d.i on or about the 8th of the month. Soon it'll appear in comp.answers and news.answers too. 0.2.4 email ------------- If you don't have access to FTP try using a FTP-by-mail server. Send a message with "help" in the subject line to the nearest one of: ftpmail@decwrl.dec.com ftpmail@sunsite.unc.edu ftpmail@doc.ic.ac.uk ftp-mailer@informatik.tu-muenchen.de ftpmail@grasp.insa-lyon.fr ftpmail@cs.uow.edu.au 0.3 Who do I complain to? -------------------------- Comments *please* to: Kerry Sainsbury Home: +64 9 276-5546 kerry@kcbbs.gen.nz (preferred) Quanta Systems Work: +64 9 377-4473 kerry@quack4.quanta.co.nz Auckland, New Zealand Fax: +64 9 309-5684 GMT+12 ----------------------------------------------------------------- Contents -------- 0 FAQ Facts: 0.1 What's new in this release of the FAQ? 0.2 How can I get the latest copy of the FAQ? 0.3 Who do I complain to? 1 Frivolous background stuff: 1.1 Who, or what, is Informix? 1.2 The Informix Time-line 1.3 How do you pronounce "Informix"? 1.4 What products to Informix sell, and what do they do? 1.5 What're the differences between Turbo/Online/SE/4GL/RDS/ESQL... 1.5.1 Online vs Standard Engine. 1.5.2 Online vs Turbo. 1.5.3 4GL vs 4GL-RDS. 1.5.4 4GL vs 4GL for Windows vs 4GL/GX 1.5.5 ESQL/C vs 4GL 1.5.6 HyperScript Tools vs WingZ 1.6 What are TPC-C benchmarks? 1.7 What are the meaning of the acronyms used in this newsgroup? 2 Not so frivolous background stuff: 2.1 Who are we - comp.databases.informix 2.2 How do I join the list or unsubscribe? 2.3 What's the Consensus on Job Postings? 2.4 Other User Groups 2.5 The Informix User Group Mailing list 3 Tell me More about... 3.1 The Integrated Debugger 3.2 4GL for Windows 3.3 I-Star/I-Net 4 Common Questions about tools: 4.1 Informix-4GL 4.1.1 I keep getting -4518 errors! How can I fix this problem? 4.1.2 How can I write to a flat ASCII file? 4.1.3 How can I read from a flat ASCII file? 4.1.4 How can I force INPUT ARRAY onto the next line? 4.1.5 How can I make a screen dump? 4.1.6 Any undocumented features that I could play with? 4.1.7 Performance tips (Code Optimization) 4.1.8 Performance tips (Design Optimization) 4.1.9 How can I use #DEFINE-style constructs, like C? 4.1.10 Why are RUN's return codes screwy? 4.1.11 Are there any RDS compatibility problems? 4.1.12 Can you link Compiled I4GL functions into a custom P-code runner? 4.1.13 How can I check if any rows exist, without OPEN-FETCH-CLOSE? 4.1.14 How do you include Printer control characters in an Informix Report? 4.1.15 How can I dynamically change Report OPTIONs at runtime? 4.2 ESQL/C: 4.2.1 Why have Informix duplicated stleng, stcopy() etc in ESQL/C? 4.2.2 How can I get a list of databases? 4.2.3 Can I use ESQL with C++? 4.2.4 Can I use ESQL with C++ under 6.0? 4.3 ACE: 4.3.1 How do I call a custom C function from ACE? 4.3.2 How can I create unique output filenames? 4.4 WingZ 1.0: 4.4.1 How can I make DataLink not pop-up 'no rows found'-style dialog boxes 4.5 Hyperscript Tools: 4.5.1 How do I run a Hyperscript Worksheet directly from a Windows Icon? 4.5.2 Which is better Datalens or built-in SQL? 4.6 Informix-4GL for Windows 4.6.1 How can I get a UK Pound sign as my MONEY code? 5 Common SQL Questions: 5.1 How can I speed up my SQL commands? 5.1.1 SELECTs using sorts or joins 5.1.2 SELECTs using NOT IN or NOT EXISTS clauses 5.2 How can I use the results of an SQL query in a shell script? 5.3 Why can't I create a view with a calc column 5.4 How can I access data outside the current database? 5.4.1 Using Standard Engine 5.4.2 Using Online 5.5 How can I SELECT rows in detail-table missing a matching header-table row 5.6 How can I SELECT a fraction (say 10%) of the database 6 Common Questions about the Engine: 6.1 What're some pointers for configuring Online? 6.2 What do I need to use MS-Access/Visual Basic with my Informix database? 6.3 Where can I get an ODBC driver? 6.4 What