Doug LawryBio

313 messages in this archive (105 questions asked, 208 answers given) — 2012-02-25 11:06:28 to 2013-01-23 11:22:35

Threads

• Limit User Connections
• OAT latest
• Error -243 ISAM -154 with Select sentence
• retiring a result-set from regex_split function (3 messages)
• Table Privileges
• User authentication /Windows
• Aborting long transaction doesn´t rollback tx
• Re: onmode -z doesn't work
• 201 Syntax Error
• rootdbs full
• Users using temporary dbspaces
• Chunks are changing ownership to root disk
• Could not position with in a table
• Restore secndary from primary fails
• Error 922
• unable to run restore (2 messages)
• Re: Switching primary/mirror chunks (RFE)
• "output to" question
• Deleting millons of rows
• New RFE - please vote
• Switching primary/mirror chunks (RFE) (3 messages)
• unable to delete rows on ph_alert and ph_alerts
• Please vote for request: In-Place Alter for varcha
• Re: Identify the sessions which using all tempspac
• ph_alert
• He's Back, Better and Bold
• Re: Auto Update Statistics Evaluation Error (2 messages)
• speed up ontape -r
• Error Message in online.log file (2 messages)
• onstat -T flag 0x40000000 (2 messages)
• Restoring Data from trans logs only (2 messages)
• Trouble in HDR land
• Truncated table still occupied many pages (3 messages)
• Using SQLTRACE (4 messages)
• create_vp: cannot allocate semaphore
• Fetch stored procedure definition in Java
• system table to keep track of dependent views?
• ER tool
• sysrstcb
• Unused Indices
• Error # 40002 (2 messages)
• Script or SQL statement
• Re: Script for stopping/starting continuous logging?
• Query to list indexes (and the tables they belong (2 messages)
• ontape pipe restore times
• RE: No more pages in a tablespace
• how to get last update of a record in a table
• Strange behaviour when using a view in 11.70.FC2
• How can I backtrack alters in table using systable
• Alter Table non-exclusive
• Stealth Marketing at its Finest!
• ids 11.70.TC1IE limits
• WindowStation/Desktop error starting IDS on Windows 2003
• question about Query with joined view
• Re: proper way to create rawdevices in Red Hat Enterprise 5.5 (2 messages)
• Removing semaphore shared memory segment aborts other informixservers
• Windows 7 64 bit SQL and Schema viewer for IDS 11.50
• proper way to create rawdevices in Red Hat Enterprise 5.5
• HP/UX to Linux - raw space setup question
• How do you force IDS to use static destination TCP port numbers? (2 messages)
• Unknown SQLCODE error
• Re: dynamic row sequence (2 messages)
• ids11.5 enable AIO on AIX 6.1
• Index creation progress
• Re: shm wrong buffer status
• Encryption in ontape for version 11.5
• immediate down notification
• Re: on-audit filtering via named pipe?
• Trigger problems
• TROUBLE CONVERTING IDS 9.40 TO 10
• -952 Authentication Error on Solaris 10
• Re: stored procedure having an arrays as parameter (IDS 9.40)
• Alter fragment stalled with CKPT REQ
• Re: Informix 4GL INSERT statement with SERIAL
• Re: TESTING IDS 11.50
• Re: TESTING IDS 11.50 (2 messages)
• Re: TESTING IDS 11.50
• Re: Just scratching my head...
• Re: Is it just me?
• Re: getting full volume info
• Re: Ontape restore hangs
• Re: Ontape restore hangs
• Ontape restore hangs (3 messages)
• Re: Fwd: informix developer tool
• Setnet32 not accepting protocol "group" (2 messages)
• ids connections lost to vpn (3 messages)
• Re: ontape restore error
• Re: Stored Procedures in SE 7.3
• why does this query not work ?
• Re: Non-printable sign
• DB infos
• Re: Hands-free Administration
• Re: Returning recordsets from stored procedures
• Re: SQuirreL and Informix
• IDS 11 archecker ignores AC_RESTORE_FILTER
• select * from calls where timestamp > ?????
• Run multiple statements from VB6 ? (2 messages)
• Re: admin tools like PC client
• Order by effect on temp tables
• @@rowcount equivalent in INFORMIX?
• Stored procedure giving syntax error in different version of informix
• Re: non alpha characters cleaning strings ??
• Re: non alpha characters cleaning strings ??
• SQuirreL SQL Client 2.4.1 with Informix Plugin
• Calling an Informix Stored Proc that Returns a value from a UNIX script
• ole db problems while linking sql server and informix (2 messages)
• Java calling a stored procedure...
• Case Insensitivity
• ESQL/C: Host variable as constant in SELECT clause
• RE: JDBC 3.00.JC3 DatabaseMetaData getColumns DATETIME bug
• JDBC 3.00.JC3 DatabaseMetaData getColumns DATETIME bug
• Re: A way to get autogenerated keys
• Re: A way to get autogenerated keys
• Re: How to drop a temp table using "if exists" logic ?
• To insert Dates in a particular format (with day of the week) into a table.
• Fetching the last sequence value allocated by any database connection
• RE: onunload limit
• =?iso-8859-1?q?PRINTING=20REPORTS=20USING=20FOUR=20J=B4S=20BDL?=
• Re: FOREACH problem in SPL
• Re: table listing
• Random Generator
• DBPING - Thanks to OTC
• Re: Case in Select Statement
• Perform screen and ACE prompt for
• record locked
• RE: IDS Version Detection.
• Retint function
• Re: Warning in PHP using informix ODBC
• dbexport problem
• 4GL REPLACE FUNCTIOn
• Re: Can I alias dbaccess to be isql ?
• Poor view performance
• Re: How to get the end value of month
• who locks a record?
• Re: function on a check constraint
• Re: Get all child table and key names of a parent table
• Re: (ancient history) 668: System command cannot be executed, 255: Not in transaction
• DTS from informix to MS SQL 2000
• SELECT * FROM <sourcetable> INTO <newtable>
• Convert "Outer" to SQL?
• Need good starter books on Informix/Genero
• Rows into columns
• Re: Setting Isolation Level
• Re: data model
• Re: To get the column information from SELECT Query. (2 messages)
• Re: To get the column information from SELECT Query.
• Re: DBINFO parameter values (2 messages)
• Re: DBINFO parameter values
• DBINFO parameter values
• Re: How to get ip address of client ?
• Finding the Position of a String Within a String
• Re: Validating sqlhosts and services
• Re: Anyone here EVER gotten Kerberos authentication working
• Re: informix market share - off topic
• Informix remote access.
• RE: IDS and Server Studio
• IDS and Server Studio
• UK IUG Meeting
• temp table existence
• How to set DBPATH for sqlexecd and SE?
• Temporary dbspace
• Informix Setnet32 and Citrix
• Re: problem defining VARIABLE
• Copy more than one instance on a single tape in Informix IDS 7.31
• 4GL Function keys(F1-F64)
• null literal in 9.3
• Re: RE: FW: Query
• I want to open a doc file in window dir using informix 4gl
• FW: Query
• ISQL Error: Could not SQLConnect
• UK Informix User Group - social event
• How to set variables in DTS
• Cognos (2 messages)
• Re: Display Array
• Question about triggers
• Re: Loading table with INT8 column
• Inserting rows into two joined tables using 'sqlca.sqlerrd1'
• long transaction job then aborted with the following error number 458
• Re: UK Informix meeting...
• Format of sqlhosts file
• Re: Eleven FAQ's About comp.databases.informix and informix-list@iiug.org
• UK Informix meeting...
• Re: Dropping a procedure.
• carriage returns within a column
• Re: load a table includes 350 000 records
• Re: How to query up the newline (||) character in SQL editor
• Re: Correction: Error (-881) : Resulting string length must be less than or equal to 255.
• Correction: Error (-881) : Resulting string length must be less than or equal to 255.
• Another Informix news item
• Another Informix news item
• Re: Tab in WORDWRAP fields
• Re: Tab in WORDWRAP fields
• Tab in WORDWRAP fields
• Tab in WORDWRAP fields
• vim, code beauty and 4gl
• Newbie question
• How many locks have been used?
• FW: Equivelant for lpad in Informix ? IDS7.31
• =?ISO-8859-1?Q?Can=B4t_recreate_index_on_temp_tab?= =?ISO-8859-1?Q?le_if_table_vanishes_by_rollback?=
• Re: Exception: com.informix.asf.IfxASFException
• Re: Unloading to two destinations
• DBEXPORT failed with *** prepare unldobj & 201 - A syntax error
• Informix on AIX (newbie).
• Re: SQL - Finding Orphans?
• Procedure with carriage return
• Interpretation of onstat -g ses, hostname column
• Informix on Linux
• how to get max length defined for a field in a table
• Re: Posting from the Informix-list
• Re: Informix 4gl Query
• Informix 4gl Query
• Re: DB2 magazine / Informix Connextion
• different results in select ?
• Hey Informix - Who Are You?
• get sqlca by select statement
• Re: Eleven FAQ's About comp.databases.informix and informix-list@iiug.org
• Re: Moving Data from Informix SE 4 to Informix SE 7
• which C compiler to use on HP-UX for 4GL
• C Code to Access and Modify C-ISAM files on AIX 4.1
• Re: 9.40 query optimiser problem
• 9.40 query optimiser problem
• UK user group (2 messages)
• Informix device permissions after SuSE reboot (2 messages)
• 4GL contract in UK Midlands
• Re: Executing run command for scripts as su
• Executing run command for scripts as su
• Re: Replication VS Triggers
• Bitwise operators in SQLs/4GLs
• Re: Re: CASE statement frustration...
• Re: CASE statement frustration...
• String length exceeding 256 bytes (error 280)
• A Question about Perform
• Re: Informix tool related question
• String Slicing in Queries
• Re: c4gl Compile Time Connection Error
• Re: 9.40 behavioural differences
• SELECT FIRST ... INTO TEMP ...
• Re: 9.40 behavioural differences
• 9.40 behavioural differences
• Re: C4gl Flags for IDS 9.4 and AIX 5.2
• Re: Spam Alert: Passing a value from Unix into 4GL ?
• Re: parameter select sql failing to prepare
• JDBC driver ( Informix & WebSphere )
• Is there anybody out there?
• Datetime data type problem with dbimport. (2 messages)
• Re: Informix permissions (IDS 9.30)
• anyone have a copy of dostats for 4gl?
• Re: How to number rows in SQL?
• Re: TYPE_FORWARD_ONLY
• Re: Unattended ontape
• Re: Unattended ontape
• Unattended ontape
• Re: Crete view from other system
• Re: need SCO Unix help please
• Stored Procedure Errors
• Re: updating 'LIST' elment from SPL
• Re: How to convert carriage return to another char string in Informix
• How to convert carriage return to another char string in Informix SQL or 4GL
• Re: The Joys of the Jet Engine
• Re: Error -25553
• Re: How can I obtain SQLCODE in SPL ? (2 messages)
• Re: 2 parameters from spl in a select statement
• RE: How can I obtain SQLCODE in SPL ?
• Re: Informix Stored Procedures with Cognos Impromptu Report Writer
• Re: Might be useful, might not
• Access 2002 ODBC Timeout Issue
• Re: leading zeroes in day, month
• Re: sqlcmd-72.00 compile problems
• Re: Any JDBC drivers for informix anywhere (ifxjdbc.jar?)
• Re: Thanks to the usergroup
• UK phone number change SQL
• UK phone number change SQL
• Re: ZEROFILL attribute problem
• Re: RDS vs Compiled?
• Re: LOCKING problem
• Re: dbaccess format question
• Re: Corrupt Table
• Re: 32 bit informix drivers
• Re: Form display problem with CHAR(1) fields