Histórico da Página

Composition Setup
import.css=/download/attachments/327912/newLayout.css

Portuguese

Informix

IMPORTANT INFORMATION

Support to version 7.31 was interrupted by the manufacturer on 30/09/2009. Thus, it is recommended that you obtain a more recent version because from this date on approval with Microsiga Protheus will be discontinued in 6 months by TOTVS.

Collation: EN_US.CP1252 (regardless of O.S.).
CLIENT 2 of Informix is approved.

Procedures are approved with Informix.
Refer to the manufacturer website to get updated information on Kernel release:
http://www-306.ibm.com/software/data/informix/pubs/roadmaps.html

Windows Environment - ODBC Configuration

The connection made by TOTVSDBAccess to use Informix Database is performed through an ODBC Driver, which must be configured in the device where TOTVSDBAccess is installed.

By configuring the connection through ODBC, some parameters of this configuration determine the database behavior. These parameters must be configured to fit the behavior expected by TOTVSDBAccess and by ERP application, since they will use this connection.

ODBC driver configuration for Informix has some configuration tabs (General, Connection, Environment, Advanced, and About... ). The important points of these settings are:

Environment - Cursor Behavior

Image Added

The default value of this parameter is 0-Close. This parameter defines the database behavior regarding the automatic cursor closing (Queries) when a "commit work" or "rollback work" is performed in a transaction.
Microsiga Protheus and TOTVSDBAccess do not expect any automatic cursor closing by confirming or aborting a transaction. Thus, Cursor Behavior must be configured with 1-Preserve for the correct operation of TOTVSDBAccess and Microsiga Protheus applications with Informix database. If this configuration is not adjusted, errors can be occurred and Microsiga Protheus applications may not work properly: database search failure, cursors ended with EOF() before returning all lines, and Stored Procedure call and execution failure. In these cases, the following errors are registered in TOTVSDBAccess LOG, in Fetch operations:
Error : -11060 (37000) - [Informix][Informix ODBC Driver]General error. ( From tODBCStatement::Fetch )

Error : 0 (S1010) - [Microsoft][ODBC Driver Manager] Function sequence error ( From tODBCStatement::Fetch )

Linux Environment - ODBC.ini Configuration for TOTVSDbAccess

ODBC.INI file is in the root directory (cd/root).

[ODBC]
Trace=0
TraceFile=/tmp/odbctrace.out
InstallDir=/usr/informix

[nomeconexao]
Database=
Servername=

CursorBehavior=1

Caption
Image Added Image Added	Discontinued or not approved by the manufacturer and supported by TOTVS.
Image Added Image Added	Discontinued or not approved by the manufacturer and by TOTVS.
Image Added Image Added	In process of discontinuation by the manufacturer and supported by TOTVS.
Image Added Image Added	Approved by the manufacturer.
Image Added Image Added	Approved by the manufacturer and by TOTVS.

O.S.	Informix 7.31	Informix 9.21	Informix 9.30	Informix 9.40	Informix 10	Informix 11.5
Windows 2000 Server	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Windows 2003 (X86)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Windows 2003 (X86_64)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Windows 2008 (X86)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Windows 2008 (X86_64)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Suse SLES8 (X86)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Suse SLES8 (X86_64)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Suse SLES8 (Itanium)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Suse SLES9 (X86)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Suse SLES9 (X86_64)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Suse SLES10 (X86)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Suse SLES10 (X86_64)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
RedHat 2.1 AS / ES (X86)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
RedHat 2.1 AS / ES (X86_64)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
RedHat 2.1 AS / ES (Itanium)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
RedHat 3 ES (X86)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
RedHat 3 ES (X86_64)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
RedHat 3 ES (Itanium)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
RedHat 4.6 ES (X86)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
RedHat 4.6 ES (X86_64)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
RedHat 5.1 ES (X86)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
RedHat 5.1 ES (X86_64)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Solaris 6	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Solaris 7	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Solaris 8	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Solaris 9	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
Solaris 10	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
IBM AIX 4.3.3 (X86)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
IBM AIX 5.1.0 (X86)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
IBM AIX 5.1.0 (X86_64)	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
IBM AIX 5L 5.2	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
IBM AIX 5L 5.3	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added
IBM AIX 6.1	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added

English

Pagetitle

	Informix
	Informix

Informix

IMPORTANT INFORMATION

Support to version 7.31 was interrupted by the manufacturer on 30/09/2009. Thus, it is recommended that you obtain a more recent version because from this date on approval with Microsiga Protheus will be discontinued in 6 months by TOTVS.

Collation: EN_US.CP1252 (regardless of O.S.).
CLIENT 2 of Informix is approved.

Procedures are approved with Informix.
Refer to the manufacturer website to get updated information on Kernel release:
http://www-306.ibm.com/software/data/informix/pubs/roadmaps.html

Windows Environment - ODBC Configuration

The connection made by TOTVSDBAccess to use Informix Database is performed through an ODBC Driver, which must be configured in the device where TOTVSDBAccess is installed.

By configuring the connection through ODBC, some parameters of this configuration determine the database behavior. These parameters must be configured to fit the behavior expected by TOTVSDBAccess and by ERP application, since they will use this connection.

ODBC driver configuration for Informix has some configuration tabs (General, Connection, Environment, Advanced, and About... ). The important points of these settings are:

Environment - Cursor Behavior

Image Modified

The default value of this parameter is 0-Close. This parameter defines the database behavior regarding the automatic cursor closing (Queries) when a "commit work" or "rollback work" is performed in a transaction.
Microsiga Protheus and TOTVSDBAccess do not expect any automatic cursor closing by confirming or aborting a transaction. Thus, Cursor Behavior must be configured with 1-Preserve for the correct operation of TOTVSDBAccess and Microsiga Protheus applications with Informix database. If this configuration is not adjusted, errors can be occurred and Microsiga Protheus applications may not work properly: database search failure, cursors ended with EOF() before returning all lines, and Stored Procedure call and execution failure. In these cases, the following errors are registered in TOTVSDBAccess LOG, in Fetch operations:
Error : -11060 (37000) - [Informix][Informix ODBC Driver]General error. ( From tODBCStatement::Fetch )

Error : 0 (S1010) - [Microsoft][ODBC Driver Manager] Function sequence error ( From tODBCStatement::Fetch )

Linux Environment - ODBC.ini Configuration for TOTVSDbAccess

ODBC.INI file is in the root directory (cd/root).

[ODBC]
Trace=0
TraceFile=/tmp/odbctrace.out
InstallDir=/usr/informix

[nomeconexao]
Database=
Servername=

CursorBehavior=1

Caption
Image Modified Image Modified	Discontinued or not approved by the manufacturer and supported by TOTVS.
Image Modified Image Modified	Discontinued or not approved by the manufacturer and by TOTVS.
Image Modified Image Modified	In process of discontinuation by the manufacturer and supported by TOTVS.
Image Modified Image Modified	Approved by the manufacturer.
Image Modified Image Modified	Approved by the manufacturer and by TOTVS.

O.S.	Informix 7.31	Informix 9.21	Informix 9.30	Informix 9.40	Informix 10	Informix 11.5
Windows 2000 Server	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Windows 2003 (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Windows 2003 (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Windows 2008 (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Windows 2008 (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Suse SLES8 (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Suse SLES8 (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Suse SLES8 (Itanium)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Suse SLES9 (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Suse SLES9 (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Suse SLES10 (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Suse SLES10 (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 2.1 AS / ES (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 2.1 AS / ES (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 2.1 AS / ES (Itanium)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 3 ES (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 3 ES (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 3 ES (Itanium)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 4.6 ES (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 4.6 ES (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 5.1 ES (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 5.1 ES (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Solaris 6	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Solaris 7	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Solaris 8	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Solaris 9	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Solaris 10	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
IBM AIX 4.3.3 (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
IBM AIX 5.1.0 (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
IBM AIX 5.1.0 (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
IBM AIX 5L 5.2	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
IBM AIX 5L 5.3	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
IBM AIX 6.1	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified

Árvore de páginas

Versões comparadas

Versão antiga 5

Nova versão 6

Chave

Informix

Informix