Jean SagiBio

584 messages in this archive (459 questions asked, 125 answers given) — 2009-06-20 01:07:13 to 2009-06-20 01:07:13

Threads

• BETA Test of New Features in dostats
• Re: data type for ip addresses
• Upgrading to Infx 11.5
• Problems accesing IDS on Windows via IPv6
• Update command
• Lies, Damn Lies and Statistics...
• Modify the "IBM INFORMIX ODBC DRIVER" Data Source
• 2008 Survey (2 messages)
• Problema con logs
• sysadmin database v11.50
• select table from table ?? (2 messages)
• DBSPACETEMP
• Unabled to drop temp table
• Why would a query work on one machine but not another?
• relocating sysutils database
• Dbspace creation
• How do I uninstall gsk7 ? (2 messages)
• Re: Just scratching my head...
• Re: Is it just me?
• size of datatypes (3 messages)
• insert into from union
• stored procedure query vs dbaccess
• Cheetah 2 on Windows Vista (64bits) (2 messages)
• How to activate dynamic explain in windows's IDS (2 messages)
• Referential constraints on raw tables... are they (3 messages)
• How to recover (6 messages)
• Given a null constraint name how to know its colum (3 messages)
• South America Informix Users Group Meeting in Sao
• Re: 4GL WITH REOPTIMIZATION
• IDS Media on DVD
• Windows Vista install problem
• Installing JDBC 3.50 on Vista 64...
• install informix 11.5 on windows vista (2 messages)
• How to use Informix Dynamic Server
• dbexport with multiple users (2 messages)
• Re: IDS On Win Vista Ultimate (2 messages)
• Re: Fwd: IDS On Win Vista Ultimate
• IDS On Win Vista Ultimate
• Re: Cheetah redux
• Re: Re: Let me be the first
• Re: Massive Delete
• Massive Delete
• Re: Re: Let me be the first
• Re: RE: Re: Let me be the first
• Re: Let me be the first
• Re: Re: Let me be the first
• corrupted page
• Re: Let me be the first
• down load IDS 9 for Linux
• Re: Re: What if XPS (or IDS) goes open source...?
• Re: Re: What if XPS (or IDS) goes open source...?
• What if XPS (or IDS) goes open source...?
• Re: RE: IDS 10 Bug? The Mystery of the Missing Data
• create tigger on online 4.x
• Re: Error trapping
• Random Generator
• SQL support byte operation like 'AND' || 'OR' (4 messages)
• Re: Re: Informix in the press...
• Re: Informix in the press...
• Re: IDS 10 Download
• Re: Re: Informix in the press...
• Re: Re: Informix in the press...
• OSTIME PARAMETER
• Informix to MS SQL 2005
• Re: Columns in each table
• update statistics
• Re: Columns in each table
• Re: Columns in each table
• Re: Re: Sequential Scan on TEMP table
• Re: Re: Sequential Scan on TEMP table
• How to tell if an Index is being used or not?
• Re: Re: Sorting Problem
• Re: Suitable Linux Version with Informix Version
• Suitable Linux Version with Informix Version
• ODBC-driver
• Re: String Right justification
• Form file not found
• Re: Re: Stuart strikes again - history is altered!
• Re: Re: Dumb DBA mistakes
• Re: Re: Dumb DBA mistakes
• Improving efficiency on char column searches (2 messages)
• Re: Whoto remove line feed control character from report output
• reorganize database
• Linked tables in SQL
• Re: Errors in stored procedure don't raise
• Re: Errors in stored procedure don't raise
• Re: Accessing image stored in an optical platter jukebox
• Re: Accessing image stored in an optical platter jukebox
• Re: Splitting field
• Re: FW: sql delete join question [124]
• Re: "Rownum" in Informix
• Re: why is it so hard to find qualified Informix developers??
• Re: Re: rollback committed transactions
• Re: rollback committed transactions
• Re: Saying yes to a no-charge IDS!
• Re: create a DB on Linux
• Re: NUMBER OF PAGES IN A REPORT
• Re: Re: IBM Gives Away DB2
• Re: IDS 10
• Re: Redbook Residencies
• Re: cross tab needs in SQL
• Re: View performance in IDS - suggestions?
• Re: Re: why can't Online 5.20 be opensourced
• Re: Manually Adding a Row to a Resultset
• Re: Re: complex duplicate row
• Re: Another Datetime/Interval question
• How to do a constraint to reference a view? (2 messages)
• Re: dbexport - exclusive locking
• IDS Upgrade from 7.30 to 7.31 / 9.30
• Re: Problem with Table fragments
• Re: Re: Informix in the news! Part Deux...
• Re: 9.30 upgrade: 9.40 or 10?
• Re: Re: Informix in the news! Part Deux...
• Re: 9.30 upgrade: 9.40 or 10?
• [Fwd: RE: How to view relationships between tables??]
• Re: David Williams looking for a new job!
• Re: Updating or deleting rows with self-referential subqueries
• Re: Re: Re: Sql to concatenate multiple rows to a single row /
• Re: dummy update
• Re: Sql to concatenate multiple rows to a single row / column
• Multiple Residency on Windows Informix 9.30 TC3
• Re: Informix 4GL Help !!
• Re: Informix 4Gl Developer Needed in Colorado
• I'd like something like this for IDS
• Re: Set Triggers Disabled and 4GL
• Re: UK Informix job posting
• Re: Optimiser choice of index
• Re: Development tools: where to? (Long)
• Re: Re: I want to open a doc file in window dir using informix
• Re: I want to open a doc file in window dir using informix 4gl
• Re: Reading DBF from Informix
• Re: I want to open a doc file in window dir using informix 4gl
• Recovering a single table from an ontape archive
• Re: Select first with rownumber ?
• Re: UK Informix job posting
• Re: RE: RE: FW: Query
• Re: RE: RE: FW: Query
• Re: HEX to DECIMAL
• Re: RE: FW: Query
• Re: FW: Query
• Re: RE: FW: Query
• Re: Re: FW: Query
• Re: FW: Query
• Re: FW: Query
• Re: ontape to filesystem
• Re: Re: Howto: Count the number of groups returned by a Select
• Re: Howto: Count the number of groups returned by a Select
• Join Order
• Re: Re: How to Restore a unique table from an ontape archive
• Re: RE: How to Restore a unique table from an ontape archive
• Re: How to Restore a unique table from an ontape archive
• [Fwd: Add Constraint]
• Re: Problem with SE-5.0 Database after altering Table
• Re: How to get UPDATE, INSERT, DELETE query on some specified
• Re: RE: Distributed Query Performance in IDS 10
• Re: RE: 4GL To GUI
• Re: Relation of OS user to Informix database user
• Re: Re: Informix DBA Position
• Re: OPTCOMPIND
• Re: RE: Upgrade recommendations
• Re: Upgrade recommendations
• Re: esql error
• Re: Re: Venting about docs
• installing 9.40.FC7 (2 messages)
• Re: Upgrade gotchas?
• Re: Re: Upgrade gotchas?
• Re: Re: No future for DB2
• Re: Re: Upgrade gotchas?
• Re: Upgrade gotchas?
• r4gl/isql FAILS AFTER IDS 10.0 INSTALLATION
• New SKIP, LIMIT of SELECT are afe (5 messages)
• Re: Re: How to set variables in DTS
• Re: How to set variables in DTS
• Re: No future for DB2 - slightly off-topic, discusses what people
• Re: getting more rows out of a table
• Read ASCII file from a 4GL program
• Re: Re: No future for DB2
• Re: New IDS Forum on IBM Developerworks website
• Re: Re: Re: Re: No future for DB2
• Re: Re: Re: No future for DB2
• Re: Re: No future for DB2
• Re: Re: No future for DB2
• Re: Re: No future for DB2
• Re: I-SQL, 4gl version 7.32.FC3
• ISQL and IDS 9.40
• Re: EGL
• Re: Re: 4GL debugger
• IDS 7.3 database is not coming up
• Re: Fw: IDS 10 Express Edition - Response from IBM
• Re: 4GL debugger
• Re: Incremental queries?
• Re: update on a primary key
• Re: Fw: IDS 10 Express Edition - Response from IBM
• Re: Incremental queries?
• Re: Re: Migrate from Informix to Mysql
• Re: Re: Migrate from Informix to Mysql
• Re: Re: verboten WAS: Insider #59: IDS Express
• Re: verboten WAS: Insider #59: IDS Express
• Re: IDS 10 Express Edition
• Re: Re: IDS 10 Express Edition
• Re: Insider #59: IDS Express
• Re: Insider #59: IDS Express
• IDS Function problem
• Re: Insider #59: IDS Express
• Re: Re: IDS Next Version - features wanted.
• Re: Re: IDS Next Version - features wanted.
• Re: Re: IDS Next Version - features wanted.
• Re: IDS Next Version - features wanted.
• Re: Re: IDS Next Version - features wanted.
• Re: Some usefull DDE information
• Sox Audit Tools (from IBM or other) for IDS v9
• Free(Open) Informix DSA
• Re: union subqueries in "from" clause (IDS 9.4)
• Re: union subqueries in
• Re: MS-Excel Properties to fill a Cell via DDE
• Installation of IDS 10 (2 messages)
• Re: raw vs. cooked files under linux
• Re: multiset and procedure
• Re: Re: Newbie to informix
• Re: Newbie to informix
• Re: Re: Re: NEED RPG2/UNIBOL36 URGENT HELP
• IDS 10 activation
• Re: Re: NEED RPG2/UNIBOL36 URGENT HELP
• Re: RE: New installation
• dbaccess output display width from cron (3 messages)
• from IDS 9.4 to IDS 10
• Re: exportacion
• Re: exportacion
• Re: non printable characters ( very Urgent )
• Re: Longtx transaction log help
• perm_r.4gi hangs?
• Re: Linux: Upgrade 731 -> 10.0
• Re: connect to database error
• Re: Longtx transaction log help
• Re: Aggregate functions on Boolean data type
• Re: Getting the last serial field inserted per session
• Re: SQL Server CE to other databases
• Re: Re: Migration question
• performance oncheck (2 messages)
• Re: Re: Need help!! Sql to Informix Migration
• Re: Re: Need help!! Sql to Informix Migration
• Re: SQL Server CE to other databases
• Re: SQL Server CE to other databases
• Re: large chunks
• Re: large chunks
• Re: Why is this possible? -- Left outer join does not work
• Why is this possible? -- Left outer join does not work well? (2 messages)
• Demo database not created installing IDS 10 on Linux (4 messages)
• Re: Looking for a copy of informix 7.2 dynamic server
• Re: Looking for a copy of informix 7.2 dynamic server
• End of Service for IDS 9.30 Apr 3005
• Re: Informix to Oracle Migration
• Re: Informix to Oracle Migration
• Re: 9th's bug
• Re: 9th's bug
• Re: Delete Only 50 rows from table
• Re: Delete Only 50 rows from table
• Re: Oracle to Informix migration
• Re: Oracle to Informix migration
• Re: 9th's bug
• Re: 9th's bug
• Re: 9th's bug
• Re: Re: Resolution of IDS/Passport Advantage availability (NOT)
• Re: Re: Resolution of IDS/Passport Advantage availability (NOT)
• Re: Re: Client SDK 2.90 - where is it ?
• Re: Re: Client SDK 2.90 - where is it ?
• IDS 10 installation with IDS 9.4 - Windows XP
• Re: Re: LIST data type
• Re: Re: LIST data type
• Re: Re: LIST data type
• Re: Re: LIST data type
• Re: Re: DBStudio for Informix NEW Version out - Free Download
• Re: Re: DBStudio for Informix NEW Version out - Free Download
• Re: indexes
• Re: indexes
• Re: Re: DBStudio for Informix NEW Version out - Free Download
• Re: problems with procedures on informix odbc driver
• Re: RE: Oracle 9.2. on AIX 5L
• Re: Re: Parameterized SQL
• Re: dbexport & dbimport in Informix
• Re: Re: oops
• Re: RE: Gurus
• Re: RE: oops
• Re: Re: Semistructured data in Informix
• Re: Semistructured data in Informix
• FourJs and IDS sessions lock
• Installing OLE DB support in IDS 9.4 (2 messages)
• Re: Re: Informix and SQL Server
• Re: Re: Sequences
• Re: Re: encrypt/decrypt data before an update/insert
• Re: RE: Informix and SQL Server
• Re: RE: Informix and SQL Server
• Re: sqlcode 37000 preparing statement with
• Re: RE: Informix and SQL Server
• Re: increase the Buffer in ISQL
• Re: Re: vim, code beauty and 4gl
• Re: RE: IDS 10.0
• Re: IDS 10.0
• IDS and grid computing?
• Re: Aubit4GL & opensource
• Re: Informix Script Language
• Re: DB2 Exam 700
• Re: Any free 4GL tools
• Re: Re: Unload to and ODBC
• Re: Unload to and ODBC
• Re: metacube availability
• Replacing Control-M Character
• Re: Re: IDS 10.00
• getting system time
• Re: Re: Server Studio
• Deleting duplicate rows from a table.
• Re: Itanium/HPUX
• Re: Database Administration Survey
• Re: Re: DBStudio for Informix NEW FREE version online for download!!!
• Re: Calling a SPL that returns LIST(...)
• Informix s/w on Windows 2000
• IDS 9.3 available download (software)
• Re: Re: how do you convert from hex to integer using SQL ?
• Re: how do you convert from hex to integer using SQL ?
• Re: Re: IDS Support for KAIO on Linux kernel 2.6+
• Re: Re: Re: missing install instructions/pieces
• Re: SPL DATETIME bug ????
• Re: Re: missing install instructions/pieces
• Re: A VoIP usergroup
• Re: missing install instructions/pieces
• Functional indexes - experiences?
• Re: IDS Support for KAIO on Linux kernel 2.6+
• Re: sysmaster database
• Re: performance using UPDATE vs DELETE/INSERT
• Re: Re: TWO questions
• Deleting 100000 rows failed
• Deleting top rows
• Re: Re: Error info in Informix?
• Re: Re: Artinsoft and e-ASG contact
• SPL - passing an argument of 'DATETIME' type (2 messages)
• Re: Re: Artinsoft and e-ASG contact
• Re: Artinsoft and e-ASG contact
• Re: Re: EGL demo afterthoughts (long)
• Re: Re: EGL demo afterthoughts (long)
• Re: Re: EGL demo afterthoughts (long)
• Re: Re: EGL demo afterthoughts (long)
• Re: Re: EGL demo afterthoughts (long)
• Postgres database vs Informix
• Re: long-awaited 9.40uc5 is there
• Re: Re: Migrating Informix to PostgreSQL
• Re: Re: Migrating Informix to PostgreSQL
• Text files
• Re: Re: Getting the number of rows returned by a select with group by.
• Re: easy question
• Re: RE: Where are the fractions of a second of CURRENT?
• Where are the fractions of a second of CURRENT?
• HELP - RESTORE A TABLE (2 messages)
• Re: gmail - very smart
• Re: Re: Trigger question: data values in a AFTER clause
• Re: Re: Trigger question: data values in a AFTER clause
• Trigger question: data values in a AFTER clause
• Re: Re: Re: Getting the number of rows returned by a select with group by.
• Re: Re: Re: Re: Getting the number of rows returned by a select with group by.
• Re: Re: Re: Getting the number of rows returned by a select with group by.
• Re: Re: Getting the number of rows returned by a select with group by.
• Re: Re: OT:Is IBM going to be marketing Informix
• Re: Re: OT:Is IBM going to be marketing Informix
• Re: OT:Is IBM going to be marketing Informix
• Re: Re: > > > > matt parker alias ericvon lunsen@yahoo.com matt parker alias deep shredder@yahoo.com matt parker alias erikvanlint@yahoo.com the date of birth of matt parker is 9 13 65 matt parker instigates hackers and other criminals against clients an
• Re: is it possible to use wait hint with cursor select?
• Re: Re: Informix 4gl Query
• Re: Re: How to cast to interval?
• Re: Informix 4gl Query
• Re: Re: How to cast to interval?
• How to cast to interval?
• Re: Informix plays nicely with OpenOffice thru JDBC - this is how
• Re: Informix plays nicely with OpenOffice thru JDBC - this is how
• Re: RE: Problems faced during migration from Informix to oracle
• Re: Re: Why there is no controlfile in Informix like Oracle ?
• Re: Re: Why there is no controlfile in Informix like Oracle ?
• Re: OT: Re: Why there is no controlfile in Informix like Oracle ?
• Re: which C compiler to use on HP-UX for 4GL
• Re: Abort long-lasting queries
• Re: RE: Informix : Bladelet Exec causes IDS Engine to crash !!
• Re: Errors on online.log
• Re: Errors on online.log
• Re: RE: RE: anything like MS-SQL
• Re: RE: anything like MS-SQL
• Re: RE: Re: anything like MS-SQL
• Re: Re: anything like MS-SQL
• Re: anything like MS-SQL
• Re: Abwesenheitsnotiz: [Informix Dynamic Server (IDS):] Digest 3348 -
• Re: Re: PHP and Informix
• Re: Re: Catching runnig SQLs
• Re: Re: SE at EOL?
• Re: Getting XML from IDS9.30
• IDS 9.4 - LOAD in SPL
• Can we go to Linux?
• Re: RE: CASE statement frustration...
• Re: Re: CASE statement frustration...
• Re: CASE statement frustration...
• Re: Re: OT - new datablade announced for informix
• Re: Re: Gripe-- Bad SQL syntax can crash server. And... PA still stinks.
• Re: Re: Gripe-- Bad SQL syntax can crash server. And... PA still stinks.
• Re: Re: Gripe-- Bad SQL syntax can crash server. And... PA still stinks.
• Re: Re: Gripe-- Bad SQL syntax can crash server. And... PA still stinks.
• Re: Re: Gripe-- Bad SQL syntax can crash server. And... PA still stinks.
• Re: informix and web services
• Re: Re: Select from (select)
• Are rowids always in increasing order?
• Are rowids always in increasing order?
• Re: Re: How to number rows in SQL?
• How to number rows in SQL?
• How to number rows in SQL?
• Re: Remove Whitespace
• Re: Unable update through WinSql
• Re: problems after installing IDS on Windows XP Home
• Re: Re: Set Isolation
• Re: Re: Query Permormance improvement: URGENT
• Re: Re: Emulation the Terminal
• Re: Setting isolation level in Ace
• Re: Emulation the Terminal
• Re: Query Permormance improvement: URGENT
• Re: Select ... INTO TEMP Table question
• Re: Re: 9.40 vs 9.21 performance
• Re: Change to Replication Licensing
• Re: Re: tracking changes in multiple instances
• Re: Re: online
• Re: online
• Re: Was: Pocket PC + Informix Now: Off Topic, as an old man reminisces
• Re: Datetime column index access
• Re: Pocket PC + Informix
• Re: Pocket PC + Informix
• Re: Pocket PC + Informix
• Re: ld: 0711-317 ERROR: Undefined symbol: .mi_var_copy
• NYC IIUG Meeting Jan 23rd
• Re: CSDK 2.01 Error -931
• Re: TechInfo Centre as was
• Re: 4GL: SQLCA.SQLERRD[2] = 0 after insert in serial field
• Re: the beauty of informix ontape-onbar against oracle rman
• Re: Database server hosed, no back-ups
• Re: Database server hosed, no back-ups
• Re: Why Isn't Anyone Talking About The Jewish Factor? ------
• Re: Websphere / EGL
• Re: 4GL 7.32 on Linux
• Re: How to convert carriage return to another char string in Informix
• Re: 4GL 7.32 on Linux
• Re: hi Cant load informix online 5.2 on linux -8 ( rpm file)
• Re: PowerBuilder and Informix
• Re: Maintenance prices DOUBLED?
• Re: Good news!
• Re: Emulation the Terminal
• Re: sql editor from informix
• Re: storing the value of PI
• Re: good GUI client
• Re: good GUI client
• Re: informix for mac
• Re: informix for mac
• Re: IIUG94UC2-ifx user group
• Re: 2 parameters from spl in a select statement
• Re: 2 parameters from spl in a select statement
• Re: 2 parameters from spl in a select statement
• Re: How can I obtain SQLCODE in SPL ?
• Re: DBD versus dblist
• Re: DBD versus dblist
• Re: DB2 Express (was Re: Re: 9.40 buggy!)
• Re: DB2 Express (was Re: Re: 9.40 buggy!)
• Re: Re: 9.40 buggy!
• Re: Java and JDBC vs 4gl
• Re: Support of sql-92 select statement
• Re: 4GL array question
• Re: Speed up alter-table execution
• Re: Support of sql-92 select statement
• Re: Support of sql-92 select statement
• Re: Re: Informix limitations, should we be using Oracle?
• Re: Re: Informix limitations, should we be using Oracle?
• Re: Informix limitations, should we be using Oracle?
• Re: query results
• Re: query results
• Re: SP Temp Tables
• Re: Problem Determination Mastery tutorials are now available for
• Re: Datatypes in Informix
• printing infinity symbol in a report
• Re: Paradigm Visual 4GL.
• Backup/Restore
• Re: Re: Does Informix-SQL have Perl-like functions?
• Re: Is it only me getting all these viruses ?
• Re: How to improve SQL
• Re: Re: -- Re: RE: How do I pass a collection type to a prepared
• Re: Re: [Solved] -- Re: RE: How do I pass a collection type to a prepared statement in [1836]
• Re: dos client driver
• Re: Reuter's article - - - IFMX a mainframe company
• [Solved] -- Re: RE: How do I pass a collection type to a prepared statement in [1836]
• [Solved] -- Re: RE: How do I pass a collection type to a prepared statement in [1836]
• [Solved] -- Re: RE: How do I pass a collection type to a prepared statement in [1836]
• Re: Re: dos client driver
• Re: RE: [Fwd: How do I pass a collection type to a prepared statement in [1829]
• Re: Re: dos client driver
• Re: Re: dos client driver
• Re: How to acrtivated Kernel Access IO (kaio) on IDS Ver 7.31.UD2 on Linux Suse 8.0 pro
• [Fwd: How do I pass a collection type to a prepared statement in
• Re: How do I pass a collection type to a prepared statement in Informix-4gl
• How do I pass a collection type to a prepared statement in Informix-4gl 7.30?
• Re: Handling temporary tables in Informix
• Re: RE: Product Defect Query
• Re: Does Informix-SQL have Perl-like functions?
• Re: my sql editor
• Re: Does Informix-SQL have Perl-like functions?
• Re: Re: User License
• Re: How to export an Informix db to MS SQL Server 2000?
• Re: Apology--LONG DISTANCE FOR 3.85 CENTS A MINUTE, NO MONTHLY FEE,
• Is Logical Volume a raw device on HPUX?
• Re: Re: How to export an Informix db to MS SQL Server 2000?
• Re: upgrade?
• Re: UPDATE STATISTICS
• Re: UPDATE STATISTICS
• Re: Crying Wolf - was Re: Clarification please
• Re: A little hint
• Re: Crying Wolf - was Re: Clarification please
• Re: Clarification please
• Re: Control for "Isolation level" at SELECT statement level
• Re: Formula interpreter
• Re: csdk download back version
• Informix Users Group Brazil
• Re: book for beginner
• Re: MAX() Function
• Re: Designs and Redesign your site for Low Price
• Re: Need Explanation
• Re: IfxSQL
• Re: Re: dbaccess
• Re: dbaccess ?? Nothing better than that ?
• Re: dbaccess
• How to do CLIPPED in Store Procedure
• Re: Informix 9.4 crash
• Re: char to int conversion
• Re: Newbie : Main differences between informix and others SGDB
• oncheck -cc errors
• Re: RE: =?ISO-8859-1?B?8PLv5OHgIPDv7O714CDiIOH69SDk4e7u+egg7uHs7+fv9+/qIOnu8/Dl6+Pp6SDy5iDOwSBDRC1ST00=?=
• Re: =?ISO-8859-1?Q?=F0=F2=EF=E4=E1=E0_=F0=EF=EC=EE=F5=E0_=E2?=
• Re: Insert from Select
• Re: Informix and Lawson Software
• Re: SQL construct not supported in informix ?
• Re: Informix crashes with wrong datatype in stored procedure
• Re: Usability labs -- IBM Data Management Conference
• Re: Problemas con DBEXPORT
• Re: SQL construct not supported in informix ?
• Re: Can't find the Informix 2.81 UC2 CSDK
• Re: Problemas con DBEXPORT
• Re: Informix 4gl / Linux download