bozonBio

402 messages in this archive (120 questions asked, 282 answers given) — 2009-09-03 14:43:27 to 2009-09-03 14:43:27

Threads

• Alarm Program Question
• 11.50FC4 question
• Interesting ontape command for IDS10 and 11 users
• ER question (4 messages)
• RE: {Spam?} RE: Creating index with upper function (2 messages)
• Re: IDS 11.5 and SDS
• Creating index with upper function (2 messages)
• ER Error Enterprise Replication (3 messages)
• Re: In place alter issue
• sum() on join with different number of columns (4 messages)
• In place alter issue (2 messages)
• Re: Complete in-place alters
• Re: Complete in-place alters
• Re: Complete in-place alters
• Re: Integer checks (3 messages)
• Re: Anyone else get the latest IIUG mailer?
• dbcopy over secure/encrypted line
• I can't get HPL on 11.50.FC1 to work
• Split table syntax and take out all constraints...
• I'll be in Paris Next Week Tuesday July 23 through the weekend
• Re: SQL Optimizing- Indexes and Order By clause
• SQL statements needs change
• Re: what is the syntax error in this code?its a small code
• How to find the current database server name with SQL?
• Re: Which table is getting light scan?
• Re: cheetah developer edition support?
• Using a SELECT INTO Statement
• Re: incremental onbars (2 messages)
• Re: Common Table Expression (2 messages)
• Re: IDS 940 UC8 and Compellent Fiber Channel Sans
• Re: unused indexes (Informix 7.31)
• Re: Common Table Expression
• Common Table Expression
• Re: Question on IDS 10 page size
• GoldenGate?
• Logical log for Temp table
• Problem with Windows domain users
• RE: Question on IDS 10 page size
• Question on IDS 10 page size (2 messages)
• Getting a bite of the Apple?
• SEQUENTIAL SCANS (9 messages)
• DYNAMIC HASH JOIN and SEQUENTIAL SCAN
• Check to see if column exists in table
• Why doesn't Informix support the simple position(str, str) returning int function? (5 messages)
• Re: cdr_serial issue
• Re: cdr_serial issue
• Fw: in place alter messing things up
• Re: in place alter messing things up
• Re: in place alter messing things up
• cdr_serial issue (5 messages)
• Re: Has any Informix DBA had to do the following?
• Re: Has any Informix DBA had to do the following?
• Re: Well he started it!!! wuz Re: IDS on a Mac?
• Re: long time to wait until "dbaccess - Database - Select" answers
• Re: Level 0 to a file.
• Nasty IDS 10.00.UC6 bug (4 messages)
• Re: oncheck -cD errors
• Peoplesoft sub-query of a sub-query.
• Re: How to update a huge table in smaller chunks
• Re: alter table in-place algorithm
• Re: Long Transaction on alter table
• Next weekday function
• question about primary key
• RE: Listing all the tables in using a dbspace in Informix
• High Performance Loader question
• dbaccess Table -- Info reason for -211? (2 messages)
• IDS Performance Problem
• Re: Check Constraint or Foreign Key Constraint
• Cost of DECODE in the Where part
• Re: Constraint indices
• SQL Fun (7 messages)
• Problem with select first into temp tables (2 messages)
• how to copy large data fast (2 messages)
• Case Insensitivity (3 messages)
• Re: Update statistics for large databases
• Re: A way to get autogenerated keys
• Off topic WAIUG: Anyone else pay 16$US for a 1min call to Europe from the Marriott?
• Re: Duplicate check (2 messages)
• Duplicate check
• Disable Constraint
• Re: A way to get autogenerated keys
• Informix produces error -1263 after system time is changed
• Re: subquery in case expression
• RE: Strong informix DBA needed in the UK
• Re: Strong informix DBA needed in the UK
• subquery in case expression (3 messages)
• Re: To insert Dates in a particular format (with day of the week) into a table. (2 messages)
• Re: How to drop a temp table using "if exists" logic ?
• Re: slow query
• Re: slow query
• slow query
• bozon - looking for an interesting opportunity
• Re: Calculate with today in if clause (2 messages)
• Eclipse Data Tools Project
• Thanks....
• Dynamic Explain plan option in version 10 (2 messages)
• how to divide two numbers in a select ?
• Re: Multiset / Inline Select
• DELETE with OuterJoin (2 messages)
• Re: Native American (was Re: Postcards - 2nd set)
• Another (probably dumb) question - IDS SQL results cache
• Re: select * from (select * from bob) and other easy stuff (5 messages)
• HPL vs. Select Into
• Re: select * from (select * from bob) and other easy stuff
• Re: select * from (select * from bob) and other easy stuff
• Re: select * from (select * from bob) and other easy stuff
• RE: Deleting all rows from standard (with loggin) table on IDS 9.40
• Massive Delete (2 messages)
• Re: dbimport error
• Re: Need your help on this strange loading problem ... Thanks
• Re: Need your help on this strange loading problem ... Thanks
• Re: Searching values all-over the database
• Multiple insert through one Query
• Re: Searching values all-over the database
• Searching values all-over the database
• Re: Fragment elimination on datetime field
• UPPER as default on a column
• Regarding varchar
• attached index
• Re: Case in Select Statement
• Senior App Developer
• Informix to MS SQL 2005
• Re: Ontape security when shipping tapes (2 messages)
• I want a String from Position N until End (4 messages)
• Re: Question for the group....
• Re: index width
• Ontape security when shipping tapes
• Re: index width (2 messages)
• coppereye anyone ? .... and onchecks
• RE: Where are my (simple) BLOBS, really? (3 messages)
• Re: Priority aging
• Re: Down Informix -
• Re: Query (5 messages)
• onstat shared memory error
• Re: Sorting Problem
• Re: data distribution question
• RE: Query
• RE: Question about sequential scans
• Re: Question about sequential scans
• Re: help with complicated query, and joining on views (3 messages)
• RE: Sorting Problem
• Sorting Problem
• Informix 9 and correlated subqueries
• Re: HDR questions
• Re: HDR questions
• systabnames & partnum
• FROM TABLE(MULTISET( In HDR
• Problems with tempdbs with IDS 9.30 UC1 and RedHat 7.1
• HDR questions (2 messages)
• Re: Simple question - can't find answer (2 messages)
• Re: refragging a table
• Re: Alternative for cursor
• Alternative for cursor (2 messages)
• refragging a table (2 messages)
• Multiset query select from (select statement) (2 messages)
• Re: Run 'onunload' on an HDR secondary?
• Re: mailx / sendmail command
• RE: mailx / sendmail command
• reorg by restore
• Re: Run 'onunload' on an HDR secondary?
• Run 'onunload' on an HDR secondary?
• Re: dbexport/dbimport (3 messages)
• How to create informix user from SQL
• Need help with a complicate sql select request (3 messages)
• Re: fragment elimination on query
• Re: fragment elimination on query
• Indexing A Function???
• SPL Contention
• SQL help
• Re: Ontape and STDIO
• using words - isolation levels vs locs
• Re: String Right justification
• String Right justification
• Informix instances with large number of tables and databases (2 messages)
• Checking indexes after large deletes (3 messages)
• Conceptual Ontape Question
• dbaccess syntax (2 messages)
• Re: Upgrading to version 10 ontape question
• Upgrading to version 10 ontape question
• Re: Dumb DBA mistakes
• Re: Upper and Lower Case with Informix SE 5
• help on onstat
• Re: using Informix unload command
• index on nulls
• Re: Upper and Lower Case with Informix SE 5
• using Informix unload command (2 messages)
• Re: Upper and Lower Case with Informix SE 5
• Upper and Lower Case with Informix SE 5
• Re: Dumb DBA mistakes
• Re: Dumb DBA mistakes
• Dumb DBA mistakes
• Informix-SQL "compability" (3 messages)
• Re: New Features IDS 10
• Multiple Informix Instances with 9.4 UC4 version
• Re: IDS - Running temp dbspaces on RAMDISK
• Re: bad page
• bad page
• Version 10 FC4 Replace issue 528: Maximum output rowsize (32767) exceeded.
• Re: Get all child table and key names of a parent table
• Re: Tampa Florida
• Re: Get all child table and key names of a parent table
• Stored Procedures Limitation
• Hardware Comparison between SUN E6900 and IBM P570 (3 messages)
• SQL "transpose" question
• Re: Finding pending in-place alters
• Re: numeric sorting on a char field having a decimal (2 messages)
• AW: Multiple instances
• Multiple instances
• Re: Another IDS Feature Request
• Re: Another IDS Feature Request
• Re: Another IDS Feature Request
• Re: Off Topic: Cesar Cruz
• Re: numeric sorting on a char field having a decimal
• Re: Off Topic: Cesar Cruz
• Re: numeric sorting on a char field having a decimal
• Re: numeric sorting on a char field having a decimal
• Re: numeric sorting on a char field having a decimal
• Re: numeric sorting on a char field having a decimal (2 messages)
• Re: Another IDS Feature Request (2 messages)
• Re: [Fwd: Insider #67: Highlights: IDS 10 - IBM's flagship database for pure OLTP and Industrial-strength, embedded computing]
• Re: Another IDS Feature Request
• Off Topic: Cesar Cruz
• Re: Another IDS Feature Request
• Re: Finding the next best answer
• Finding the next best answer (2 messages)
• Re: Another IDS Feature Request
• Re: Another IDS Feature Request
• Error -1820 in Informix
• Re: IDS Feature Request List (including potential new requests). (2 messages)
• Re: Retrieving from 2 different databases via a single perl DBI::ODBC connection
• Re: Retrieving from 2 different databases via a single perl DBI::ODBC connection
• sysmaster question
• Retrieving from 2 different databases via a single perl DBI::ODBC connection
• Re: IDS Feature Request List (including potential new requests). (4 messages)
• Re: SQL to search for column name
• Re: IDS Feature Request List (including potential new requests) - FETCH FIRST
• Re: SQL to search for column name
• Re: SQL to search for column name
• Re: IDS Feature Request List (including potential new requests). (2 messages)
• bozon - off topic
• Re: IDS Feature Request List (including potential new requests). (3 messages)
• Re: IDS Feature Request List (including potential new requests).
• Help! blobs in IDS10.0 fail
• Re: IDS Feature Request List (including potential new requests).
• Re: IDS Feature Request List (including potential new requests).
• Re: composite indexes and filter
• Re: composite indexes and filter
• PSORT_DBTEMP versus DBSPACETEMP
• Re: cross tab needs in SQL
• AW: composite indexes and filter
• Re: Tool to Record Database changes (inserts, deletes, etc.)
• Re: "IDS 10.0 Cities Tour 2006"
• Re: Max and min date value in Informix IDS 7.31
• Re: Raw device VS cooked file - any benchmark recently done?
• Re: "IDS 10.0 Cities Tour 2006"
• Re: "IDS 10.0 Cities Tour 2006"
• "IDS 10.0 Cities Tour 2006"
• AW: IDS Feature Request List (including potential new requests).
• Re: IDS Feature Request List (including potential new requests). (2 messages)
• RE: cross tab needs in SQL
• Re: Petulent Little Bitches - was: How to build the regex datablade
• Re: IDS Feature Request List (including potential new requests). (3 messages)
• Re: IDS Feature Request List (including potential new requests).
• Re: Having problem with distinct and count (3 messages)
• Re: IDS Feature Request List (including potential new requests).
• Re: cross tab needs in SQL
• Re: IDS Feature Request List (including potential new requests). (2 messages)
• cross tab needs in SQL
• Re: IDS Feature Request List (including potential new requests).
• Re: Upgrading from 9.21 to 10 planning
• Upgrading from 9.21 to 10 planning
• Re: Informix date functions help
• Informix date functions help (3 messages)
• Re: DB2 RAISE_ERROR equivalent in IDS
• Re: OUTER issue - please help
• OUTER issue - please help (2 messages)
• Informix stored procedure
• RE: Systables partnumber
• Rename Stored Procedure in Informix IDS 7.31
• Systables partnumber
• Re: Sql to concatenate multiple rows to a single row / column
• Sql to concatenate multiple rows to a single row / column
• temp table existence
• Re: IFX_FLAT_UCSQ
• IFX_FLAT_UCSQ
• Temporary dbspace
• Insert unique values problem.
• Reporting [Graph / Chart] packages for Informix?
• help request for sql select
• Re: Stored Procedure performance
• External backup/restore - an idea - comments please
• Copy more than one instance on a single tape in Informix IDS 7.31
• Re: null literal in 9.3