How to find the FAQ...

Posted in 1994

Kerry Sainsbury — Wed, 28 Dec 1994 20:01:29 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <3dfepa$5ni@panix3.panix.com>, sal@panix.com (Salvatore Denaro) wrote: > I am looking for the informix FAQ. Anyone have it? > Where can I get a copy? Can someone send it to me? > THE INFORMIX FAQ ---------------- Here's the Table of Contents for the Informix FAQ, and instructions for how to retreive a complete copy of the FAQ. There hasn't been an update for a month or so because... 1. I've messing about helping with dbdiff 1.4 2. I've been converting the FAQ to HTML (looks really sexy too!) 3. It's Summer! The beach is rather more attractive than my PC Regards, Kerry S kerry@kcbbs.gen.nz --------------------- 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 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 error messages are caused by locking problems? 6.5 What should I use instead of kill -9? 6.6 How can I tell what version I'm running? 6.7 Locking in pre-6.0 engines 6.7.1 What is the "Twin Problem"? 6.7.2 How does this work and what are the ramifications? 6.8 Space reclamation 6.9 Online Disk Fragmentation 6.10 Why do UPDATE STATISTICS? 6.11 How do we get serial field starting values for a table 6.12 Can I count the number of rows SELECTed, without using SELECT COUNT? 6.13 Is the number of rows processed in the SQLERRD structure accurate? 6.14 Interpreting SysColumns.ColType and SysColumns.ColLength 6.15 More tuning suggestions for Online 6.16 DATETIME, INTERVAL and other tricks 7 Connectivity Questions 7.1 I-Net/Star Security 7.2 I-Net is slow... Help! 8 DBA Issues 8.1 Performance - make it go faster! 8.2 Should I use Online DSA mirroring? 8.3 Questions about NFS mounted databases 9 Configuring things 9.1 Environment variables 9.2 How do you read termcap's ZA string? 9.3 Where can I get a termcap for ...? 10 Gimme something for nothing, what's available? 10.1 Informix Archive Sites 10.2 Is there a Perl interface to Informix? 10.3 What about Mac Client Software? 10.4 Is there an RDS de-compiler available? 10.5 What about a GUI interface? 11 Miscellany 11.1 What machines get ported to first? 11.2 I've finished the FAQ, what else can I read? 11.3 Is there any Informix info on The Web? 11.4 List of major bugs fixed in the various versions 11.5 What is Informix-Link? 11.6 Does Informix run under Linux? Appendices APPENDIX A Temporary String Space (TSS) APPENDIX B Sample 4GL Routine to read ASCII files APPENDIX C Sample C Routine to read ASCII files APPENDIX D C Routine to give a list of databases APPENDIX E How to interpret syscolumns (in English) APPENDIX F How to interpret syscolumns (in 4GL) APPENDIX G GUI builders summary APPENDIX H Shell to list Informix versions APPENDIX I DATETIME, INTERVAL and other tricks APPENDIX J Dynamically changing Report OPTIONs Credits --------------------- 0 FAQ Facts ------------ 0.1 What's new in this release of the FAQ? ------------------------------------------- NEW!: 4.1.15 How can I dynamically change Report OPTIONs at runtime? 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 11.6 Does Informix run under Linux? APPENDIX J Dynamically changing Report OPTIONs IMPROVED! 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.