Peter LancashireBio

439 messages in this archive (423 questions asked, 16 answers given) — 1997-06-12 13:56:40 to 1997-06-12 13:56:40

Threads

• more on primary key and index
• normalization steps
• i4gl - programs are limited.
• When will a view ( joined tables! ) be updateable?
• Validating User Input
• How to access columns with large names
• Help: I4GL/C reports firing AFTER GROUP OF triggers erroneously
• Error 567 with informix connect
• c function in R4GL
• Printer escape sequences in SE table
• Any perfrmant solution for this type of Query ?
• cast integer to string
• Converting 7-bit ascii to 8-bit ascii
• RE: Referential Constraint (2 messages)
• Editing array of rows in i4gl
• Perform Screens
• Re: What flag to set?
• Re: illegal character error with INSERT statement and &BIND
• Re: WordWrap Cores
• Re: Informix and 255 fields
• Re: Dynamic 4GL
• Re: Dynamic 4GL
• Re: test/production setup
• Re: SCO OpenServer 5 & Informix 4
• Re: and'ing two values
• Re: Linux:Interactive SQL?
• Re: Informix for Dummies?
• Re: Error 1279 ???
• Re: INFORMIX HELP !!!
• Re: Array fetch using cursor
• Re: Informix 4.1 inquiry
• Re: Information|
• Re: Insert loop on INPUT ARRAY
• Re: unexpected NULL values
• Re: String too long
• Re: Informix SE SQL knows JOIN as does Interbase ?
• Re: DBESCWT
• Re: VARCHAR: Working to design, but why?
• Re: DBESCWT
• Re: Writing reports
• Re: WORDWRAP gives Segmentation Violation
• Re: Using True Type fonts for Report output..............
• Re: unexpected NULL values
• Re: Pros & Cons of makefiles vs. i4gl
• Re: informix se7.12 - dbexport problem
• Re: easy database design
• Re: DBESCWT
• Re: Syntax of two simple queries
• Re: Coredumps and 4GL
• Re: Picture and Form.
• Re: 4GL variable substitution in SQL statements - a feature request
• Help: Where can I find the most recent IDS Personal Edition?
• Re: WHERE IN vs. WHERE OR OR OR
• Re: Posting from the Informix-list
• Re: Informix 4GL Version 1.10 bcheck fails
• Re: subscripting in select statement
• Re: Posting from the Informix-list
• Re: CASE WHEN construct in informix??
• Re: 4GL variable substitution in SQL statements - a feature request
• 4GL variable substitution in SQL statements - a feature request
• Re: Informix Row Locking
• Re: Error handling in 4gl.
• Re: wich is better, VISUAL BASIC..POWERBUILDER..etc
• Re: Problem upgrading c4gl to 7.20 (variable initialisation)
• Re: NULL value
• Re: How can I printing non-printable chars in 4GL?
• Re: get_fldbuf()
• Re: functions as SPL's
• Re: About serial type
• Re: wich is better, VISUAL BASIC..POWERBUILDER..etc
• Re: Relay Module does not work
• Re: informix 4GL and ESQL/C
• Re: LIKE clause
• Re: UNLOAD Problems
• Re: Unknown error message 4076
• Re: rgetmsg
• Re: get_fldbuf()
• Re: dinamic 4gl error 6084
• Re: Date to Time conversion
• Re: Ordenacion de arrays.
• Re: nt file types
• Re: Information STORED PROCEDURES
• Re: y2k on informix
• Re: count distinct
• Re: Version of a .4go?
• Re: SQL help needed.
• Re: simple question on forms
• Re: Problems with an outer join. It joins a second table even it should not, there is no records in a second for specified criteria.
• Re: passing variables in stored procedures
• Re: Horisontal scroll in input array?
• Re: Horisontal scroll in input array?
• Re: 4GL: Decimal type manipulation
• Re: Helo, someone there??
• Re: 4GL: Decimal type manipulation
• Re: 457: SQL engine terminated unexpectedly - please help
• Re: passing variables to sql statements in a Unix shell script
• Re: 4GL RUN command question
• Re: Trying to use a SELECT ...INTO Command with InterBase, Sybase, and Informix
• Re: Quality control - was Re: lmatter[1,6] = '011191' does not work, but ...
• Re: NEED SQL HELP PLEASE, SELECT DISTINCT QUESTION
• Line numbers reported for errors on 4GL/C 6.02 are too small
• Re: Informix Database Admin Guide...Out of Date ?
• Quality control - was Re: lmatter[1,6] = '011191' does not work, but ...
• Re: Informix on Linux
• Re: What is the Installation procedure of Informix?
• Re: Sending messages to terminals
• Re: Order of results with "where col in (...)"
• Re: how to search for a keyword within a text field?
• Re: editor + faq?
• Re: Can Anyone Help
• Re: Two informix versions
• Re: Transaction log under SE v5.
• Re: Two informix versions
• Re: Imprimir graficos en Report.
• Re: I4GL to C converter
• Re: editor + faq?
• Re: Dynamic-4GL on NT question
• Re: Storing formulas
• Re: Stored Procedure does not show column names.
• Re: Evaluate an string.
• Re: DBDATE - Inside Informix 4gl
• Re: Can we change the column width of a column in a live database?
• Re: Why following ksh script not works in crontab?
• Re: variable passed into a SQL statement from a shell script
• Re: Outputting rows in fixed length format
• Re: Licensing software
• Re: editor + faq?
• Re: 4GL/Unload problem ..
• Re: Randomize data from SQL statement
• Locking table sysprocauth bug in SE 7.23UC13 - workarounds?
• ESQL/C 5.00 to SE 7.23 - can I use 7.23 SQL?
• Re: Y2K and forms
• Re: Look for answers
• Re: How can I start Informix SE
• Re: GROUP BY Question
• Re: Any Assistance please - Wrong return codes in SQL
• Re: X-Windows Emulator
• Re: SELECTing first x results (a FAQ?)
• Re: Timeout for lazy users - Help Needed
• Re: SELECTing first x results (a FAQ?)
• Re: Question
• Re: inserting chars at the beginning of a string?
• Re: #include is a foreign language
• Re: #include is a foreign language
• Re: ORACLE function "TRANSLATE" in IDS 7.30
• #include is a foreign language
• Re: informix ms-access sort problem
• Re: ����� . �������� ��� ����� ��������� ����������� ��� �����
• Re: Decimal exponent (power) in i4gl?
• Re: Questions on ace reports.
• Re: Decimal exponent (power) in i4gl?
• Re: 4gl question
• Re: Cursor in a report
• Re: Cannot open file 'netsrv.iem'
• Re: Named pipes?
• Re: LOAD ? UNLOAD ?
• Re: Informix SE: error -1339
• Re: USING Format for DATES
• Re: ASCII character in a string
• Re: what will happened ?
• Re: Leap Year..................!, leap seconds...
• Re: 1 Byte Integer Type ?
• Re: Moving SE Database and logfile
• Re: License daemon
• Re: Leap Year..................!, leap seconds...
• Re: Leading zeros in sql
• Re: Help needed with displaying arrays in 4gl
• Re: Substrings in Informix SQL
• Re: Beginner's Question...
• Re: Real Newbie Question
• Re: Problems with primary key
• Re: Special Characters
• Re: Two interesting features of Sybase that Informix may want
• Re: INSERT cursor -- part two - 4GL error logging
• Re: Leading zeros in sql
• Re: blanks in LOAD-file
• Re: Optimiser leaves redundant joins in views
• Re: TUNSQL, Error 461
• Re: Informix-SE transaction logging
• Re: Construct Line Length Limit
• Optimiser leaves redundant joins in views
• Re: Year 2000 - code scanning ???
• Re: Process in which to log certain Inserts, Updates, and Deletes
• Re: Problem about Informix and Xenix
• Re: How to list alle tables in database
• Re: Informix stock
• Re: Can someone please help me with a SELECT?
• Re: 4GL and writing reports to a report
• Re: 4GL 7.2 install
• Q: Optimising joins with views in SE, versions 7.12 to 7.23
• Re: Informix stock
• Re: Index Creation Questions
• Re: Tool like dbaccess without DML
• Re: Prompt message...
• Re: Need a SQL expert help : How to create a trigger for DELETE ???????
• Re: Default Values in outer joins
• Re: ISQL vs. 4GL
• Re: row level security
• Re: Update prob. w/ I-SE logfile
• Re: Using SQL to return random rows to an Array, and then randomly select items from that array
• Re: Informix 7.14 on AIX & SCO UNIX
• Re: Current function does not work!
• Re: GLOBALS declaration in Informix-RDS and 4J's
• Re: Multiple instances of SE?
• Re: Dynamic-4gl runner
• Re: Informix and Linux
• Re: General Questions From Informix Newbie
• Re: General Questions From Informix Newbie
• Re: Informix SE 7.x: Does it support data types 'text', 'varchar'??
• Re: "create or replace" a stored procedure or a trigger
• Re: Question regarding positioning within "input array"
• Re: (0)RDBMS for free text indexing
• Re: current function in long running strored procedure
• Re: How many CODD rules INFORMIX supports
• Re: 4GL forms - how do I avoid a blank line at bottom of window?
• 4GL forms - how do I avoid a blank line at bottom of window?
• Re: How to start?
• Re: WGS 7.x STORED PROCEDURES DO HAVE A POOR PERFORMANCE VS ON LINE 5.x?
• Re: Violations and Filtering mode
• Re: Portable schema?
• Re: Desperately need help
• Re: Informix Data Director for VB
• Re: Stored Procedures & removing Blanks
• ROM 2.1 works (partially) with SE
• Re: execute SPL in 4gl
• Re: *.wkz database conversion to Access?
• Re: How to create user on Informix
• Re: Trigger Problem
• Re: SQL problem
• Re: Functions List in Informix Database.
• Re: Row position in scroll cursor
• Re: SQL problem
• Re: Turning off indexes
• Re: 4GL Compilation Problem
• Re: Calling C function from SPL
• Re: FW: 4GL porting for 4.x to 6.x
• Re: Informix website broken?
• Re: [Request]the program for analyzing the SQL statements?
• Re: Microsoft and Informix
• Re: Error -302: No GRANT option or illegal option on multi-table view.
• Re: SQL problem
• Re: Informix 4GL to Java Migration Tool and Y2K
• Re: A question about OPTIONS statement
• Re: Stored procedure executing system calls
• Re: Error -302: No GRANT option or illegal option on multi-table view - SOLVED
• Re: 4GL interrupt handling
• Error -302: No GRANT option or illegal option on multi-table view.
• Re: using function key
• Re: how to use function key
• Re: Dead Administration Tools...
• Re: What is latest Engine to still support SQL Tool Char Based (Dumb Terminals)
• Re: IIUG - New engine survey, your input needed
• Re: Time-Variable
• Re: I need help with my e-mail address
• Re: Does Relational Object Manager work with SE?
• Does Relational Object Manager work with SE?
• Re: Type casting qustion
• Re: Informix 4GL - Help is required
• Re: ACE to 4GL
• What is 4JS an abbreviation for?
• Re: Stairs database
• Re: Informix to resell 4Js as Informix Dynamic 4GL
• Re: Q: INFORMIX Locking vs DB2 Locking
• Re: Fuzzy Searches
• Re: Constraint Ownership
• Re: Some SQL-Questions!
• Re: Roles and Security
• Where is Informix with mobile databases?
• Informix to resell 4Js as Informix Dynamic 4GL
• Re: Unix OS compatibility with Informix Products
• Re: Performance Issues: "order by"
• Re: Duplicate Index Keys
• Re: Unix OS compatibility with Informix Products
• Re: output to terminal with SQL
• Re: Need Informix 4GL books
• Re: I-4GL: Dirty memory (uninitialized variables)
• Re: SYSTEM call from trigger error
• Re: Y2K Issues in Informix
• Re: Pre-ESQL/C Informix Product??
• Re: Fact???
• Re: Development
• Re: Bug 83048
• Re: Who locks my table? Help!
• Re: What happen Informix?
• Re: Using INS & DEL keys with Informix 4GL
• Re: Can you use two COUNT(DISTINCT mycol) expressions in a SELECT list?
• Re: Using INS & DEL keys with Informix 4GL
• Re: Character to numeric conversion error
• Can you use two COUNT(DISTINCT mycol) expressions in a SELECT list?
• Re: Can I hide the structure of a database?
• Re: Reading a temp table
• Re: ESQL/C error message
• Re: Capturing SQL
• Re: Automatic creation of PK with Triggers ...
• Re: Application development
• When do 4GL windows become current automatically?
• Re: how to?
• Re: renaming an index
• Re: Referential integrity
• Re: order by, limited functionality
• Re: Temporary table and virtual column
• Re: How, using I4GL, do you evaluate a numerical expression held in a CHAR variable
• Re: Yahoo - Informix Revitalizes 4GL Application Development Too
• Re: ORDER BY within REPORT routine
• Re: Yahoo - Informix Revitalizes 4GL Application Development Too
• Re: WHENEVER ANY ERROR CONTINUE fails
• Re: What is FASTER than Inormix ?
• Re: Newby help, please - shrinking table size
• Re: insert newline character
• Re: Identifiers max 18 character?
• Re: Date Conversion Error 1218
• Re: 4gl reports
• Re: Update with a correlated subquery - YUCCH
• Re: Design Question: Keys using multiple Databases
• Re: which informix product has these libraries?
• Re: Select a column that is not in the order-clause ?
• Re: Excluding multiple items from the selection criteria
• Re: dbload rejects
• Re: Cursor Problem
• Re: Help required with SQL query
• Re: ESQLC prepare/execute/free causes memory leak on server
• Re: Copying data between databases
• Re: [?]Menu development tool documentation
• Re: Slow query respons
• Re: Informix Cron Job
• Re: Unix commands in isql
• Re: Substitution Variables
• Re: Informix 7.3 new features
• Re: Gregorian Calendar switch
• Re: Rapid Development system
• Re: 4gl Libraries
• Re: Very strange SQL problem
• Re: Randomly ordered select. How is it done?
• Re: 4gl Libraries
• Re: Role utilisation problem
• Re: Puzzling forms
• Re: Why composite indexes ?
• Re: new Hyperbase format for database
• Re: Insert triggers, is this a bug, is there a work around? - CHECK
• Re: [Q] How to convert numerical to character ?
• Re: Write in C++ and DIE a DOG's death?? High speed box comming!
• Re: NT vs Unix Performance HELP!
• Re: count(*) <> "wc -l" of unload file
• Re: C & Embedded SQL (Informix 7.13 on SUN) basic question
• Re: Anybody got any speed suggestions?
• Re: [Question] I want to get the system date and time
• Re: User License Question ...
• Re: Q of UNIX command in procedure
• Re: Informix Connectivity
• Re: Clustered index question
• Re: Q: executing sql script from within another sql script?
• Re: [Q] Select Problem
• Re: The keyword 'distinct' question
• Re: Puzzling forms
• Re: NEED HELP!! NEED TO GENERATE RANDOM INTEGERS.
• Re: bizaar problem with 4gl reports
• SE 7.12 CREATE TABLE leaves orphaned constraints on error
• Re: help
• Re: Write in C++ and DIE a DOG's death?? High speed box comming!
• Re: SQL in 4gl
• Re: Informix Tech Support?
• Re: Database Triggers
• Re: ESQL/C question
• Re: rgetkey and mvcur C-extensions
• Re: Help : DataBase sample
• Re: vt terminal
• Re: view table
• Re: SQL Query Output
• Re: redirecting keyboard entry to ascii file
• Re: Question concerning log files
• Re: embedded sql in C
• Re: No. of rows selected
• Re: Informix privileges
• Re: Informix 4.0 on SCO
• Re: WorkGroupServer 7.22 Win NT & Client 6.02 SCO Unix
• Re: Preventing Indexes on Foreign Keys
• Re: Need method to disallow special characters
• Informix 4GL INPUT ARRAY - can you abort a row insert or delete?
• Informix 4GL INPUT ARRAY - can you "carry along" program variables?
• Re: Stored Procedure Problem
• Re: Passing a parameter from a C program to an Informix 4gl program
• Re: How to set TERMINFO on SCO
• Re: HELP : S.E (7.x) nearly faster than OWS (7.x)
• Re: Emptying Tables
• Re: BOOK's talk about informix 4gl
• Re: Views. Who use them ?
• Re: SQLCODE and ISAM errors
• Re: Equivalent to Oracle's describe
• Re: converting sequential to line sequential
• Re: SE sqlhosts/services/ip problem
• Re: PAGE HEADER !!!!
• Re: Informix NT vs Unix
• Re: Informix left standing
• Re: Informix datetime type
• Re: Help with error message please
• Re: formbuild error
• Re: ANSI Mode: Who use it ?
• Re: Accessing program variables across 4gl files in the same executable
• Re: About 4GL
• Re: 4gl
• Re: optimizing - sqexplain
• Re: Looking at temp tables
• Re: Cleaning $DBTEMP??
• Re: Boolean complement of a pair of OR clause
• Re: Why does fgl_drawbox() draw a box made out of "x"s, "q"s, etc?
• Re: Report to File?
• Re: Informix Software is Finished...
• Re: Informix Bug: Fetch Last
• Re: copy RDSQL from SCO XENIX > SCO UNIX/ODT/etc?
• Re: Cannot delete records on SE5
• Re: Help! Need Text Database
• Re: Strw Poll : I-4GL for NT
• Re: SQL query re unions and nulls
• Re: Please HELP ME !!!
• Re: Millenium Problems
• Re: How Does One Become a DBA?
• Re: Strw Poll : I-4GL for NT
• Re: SQL query re unions and nulls
• Re: SQL query re unions and nulls
• Re: Collecting ISAM Errors
• Re: calling stored procedures from 4GL
• Re: Using string values as var names in 4GL
• Re: Security and the ODBC
• Re: LOAD (ignoring errors)
• Re: 4gl keyboard mapping?
• Re: Tables in a database, mode ANSI
• Re: Tables in a database, mode ANSI
• Re: LOAD (ignoring errors), constraint violations
• Bug in AVG under GROUP BY - gives INCORRECT RESULTS - v7.xx
• Re: Max field name length
• Re: Informix and dBase
• Re: WHENEVER ANY ERROR
• Re: rowid's changing - sperform use of rowids
• HELP: SE 7.10.UD1 on SCO: AVG() in GROUP BY treats NULL as zero
• Re: ISQL Question
• Re: Importing dBase III files
• Re: AN INFORMIX WISH LIST - DRAFT - NOT FINAL TILL JULY 18, 1997
• Re: delete duplicate rows, how???