https://wiki.ispirer.com/ 2026-04-30T20:29:46+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types-to-sql-server?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix (IDS) Data Types - Mapping to Microsoft SQL Server Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x, Microsoft SQL Server 2008, 2005, 2000, 7.0 and 6.5 * Informix Data Types * SQL Server Data Types Overview Informix Data Type SQL Server Data Type Character Data Types text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/data-types?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) Data Types Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x * Informix to SQL Server Data Types Mapping Overview Informix Data Type Parameters and Range Character Data Types CHAR(n) - Fixed-length character data 1 <= n <= 32767, default is 1 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/error-messages?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) - Error Messages This article describes the frequently-used error messages and codes in Informix Dynamic Server (IDS) 11.50 and earlier. -239 Could not insert row - duplicate value in UNIQUE INDEX The row that is being inserted or updated contains a duplicate value of some columns on which an unique constrains is defined. Returned for repeatable read isolation, see also text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/functions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Functions * SQL Functions Mapping to Other Databases * Numeric Functions * ABS * ACOS * ASIN * ATAN * ATAN2 * COS * EXP * LOGN * LOG10 * MOD * POW * ROOT * ROUND * SIN * SQRT * TAN * TRUNC * String Functions * CHAR_LENGTH * INITCAP * LENGTH * LOWER * LPAD * OCTET_LENGTH * REPLACE * RPAD * SUBSTR * TRIM … text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/identifiers?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - Identifiers This article describes identifiers in Informix Dynamic Server. Identifier Rules Informix - Identifier Rules First Character An alphabetical character and underscore (_) Subsequent Characters Alphanumeric characters, underscore (_) and dollar sign ($) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/instance-database-owner-object?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - Instance, Database, Owner and Database Object This article describes instance, database, owner and database object concepts in Informix Dynamic Server (IDS) 11.50 and earlier. Instance Informix instance is a database server software that manages one or more Informix IDS databases. Users login to an instance and access databases and database objects (tables, views, procedures etc). text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/migration-assessment?rev=1741078744&do=diff User Documentation Ispirer Assessment Tools Overview Pricing Informix Migration Assessment * Collecting Information text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/set-lock-mode?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) - SET LOCK MODE Statement Informix - SET LOCK MODE Statement Syntax SET LOCK MODE TO { NO WAIT | WAIT [seconds] } Description SET LOCK MODE defines how to handle a process that tries to access a locked row or table. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/statements?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix Dynamic Server (IDS) - SQL Statements This article describes the SQL Statements supported by Informix Dynamic Server (IDS) 11.50 and earlier. * SET LOCK MODE text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/string-functions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - String Functions This article describes string functions in Infrormix. Overview Function Description TRIM() Removes leading and/or trailing pad characters from a string TRIM Informix - TRIM Syntax TRIM([BOTH | LEADING | TRAILING [pad_character] text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/informix/techniques?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Informix Migration Pricing Informix - Techniques * Returning Information as Result Set (Dummy Tables)