Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.
Composition Setup
import.css=/download/attachments/327912/newLayout.css
Support to version 7.31 was interrupted by the manufacturer on
Portuguese

Informix

 

INFORMAÇÕES IMPORTANTES

A versão 7.31 teve seu suporte descontinuado pelo fabricante na data

IMPORTANT INFORMATION

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

, recomendamos sua atualização para uma versão mais recente, pois a partir dessa data a homologação com o Protheus será descontinuada em 6 meses pela TOTVS.

Collation: EN_US.CP1252 (

regardless of

independente do S.O.

S.

)

.

 
Está homologado o CLIENT 2

of

do Informix

is approved

.

Procedures

are approved with Informix.
Refer to the manufacturer website to get updated information on Kernel release:

são homologadas com Informix.

Consultar o site do fabricante para obter informações atualizadas sobre o release do Kernel: 
http://www-306.ibm.com/software/data/informix/pubs/roadmaps.html

Ambiente Windows
Environment
- Configuração de ODBC
ConfigurationThe 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
A conexão realizada pelo TOTVSDBAccess para utilização do Banco de Dados Informix, é realizada através de um Driver ODBC, que deve ser configurado no equipamento onde o TOTVSDBAccess está instalado.

Ao configurar a conexão via ODBC, alguns parâmetros desta configuração vão determinar o comportamento do banco de dados. Estes parâmetros devem ser configurados para se adequar ao comportamento esperado pelo TOTVSDBAccess e pela aplicação ERP que vão utilizar esta conexão.

A configuração do driver ODBC para Informix possui algumas abas de configurações (General, Connection, Environment, Advanced,
and
e About ... ).
The important points of these settings are:
Os pontos importantes destas configurações são: 

Environment - Cursor Behavior
Image Removed
Image Added
The default value of this parameter is

O valor default para este parâmetro é "0-Close
. This parameter defines the database behavior regarding the automatic cursor closing (Queries) when a
". Este parâmetro define o comportamento do banco com relação ao fechamento automático de cursores ( Queries ) quando efetuado um "commit work"
or
ou "rollback work"
is performed in a transaction
em uma transação.
Microsiga

O 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
e o TOTVSDBAccess esperam que não haja nenhum fechamento de cursor automático ao confirmar ou abortar uma transação. Deste modo, a configuração do "Cursor Behavior" deve ser igual a "1-Preserve", para o correto funcionamento do TOTVSDBAccess e das aplicações Protheus com o banco Informix.

Caso esta configuração não esteja adequada, podem ocorrer erros e mal-funcionamento de aplicações Protheus, como falhas em buscas de dados, cursores que terminam em EOF() antes de todas as linhas serem retornadas, e falhas na chamada e execução de Stored Procedure. Nestes casos, os seguintes erros são registrados no LOG do TOTVSDBAccess, em operações de Fetch:

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 )
Ambiente Linux
Environment
- Configuração de ODBC.ini
Configuration for
para TOTVSDbAccess
O arquivo .ODBC.INI
file is in the root directory
está localizado no diretório raiz do root (cd /root). 

[ODBC] 
Trace=
0

TraceFile=/tmp/odbctrace.
out
out 
InstallDir=/usr/
informix
informix 

[nomeconexao] 
Database= 
Servername= 

CursorBehavior=1
Caption
Image Removed Image Removed
Discontinued or not approved by the manufacturer and supported by TOTVS.
Image Removed Image Removed
Discontinued or not approved by the manufacturer and by TOTVS.
Image Removed Image Removed
In process of discontinuation by the manufacturer and supported by TOTVS.
Image Removed Image Removed
Approved by the manufacturer.
Image Removed Image Removed
Approved by the manufacturer and by TOTVS.
Legenda
Image Added Image Added
Descontinuado ou não homologado pelo fabricante e suportado pela TOTVS.
Image Added Image Added
Descontinuado ou não homologado pelo fabricante e pela TOTVS.
Image Added Image Added
Em processo de descontinuação pelo fabricante e suportado pela TOTVS.
Image Added Image Added
Homologado pelo fabricante.
Image Added Image Added
Homologado pelo fabricante e pela TOTVS.
S.O
O.S
.Informix 7.31Informix 9.21Informix 9.30Informix 9.40Informix 10Informix 11.5
Windows 2000 Server
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Windows 2003 (X86)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Windows 2003 (X86_64)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Windows 2008 (X86)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Windows 2008 (X86_64)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Suse SLES8 (X86)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Suse SLES8 (X86_64)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Suse SLES8 (Itanium)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Suse SLES9 (X86)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Suse SLES9 (X86_64)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Suse SLES10 (X86)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Suse SLES10 (X86_64)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
RedHat 2.1 AS / ES (X86)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
RedHat 2.1 AS / ES (X86_64)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
RedHat 2.1 AS / ES (Itanium)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
RedHat 3 ES (X86)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
RedHat 3 ES (X86_64)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
RedHat 3 ES (Itanium)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
RedHat 4.6 ES (X86)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
RedHat 4.6 ES (X86_64)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
RedHat 5.1 ES (X86)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
RedHat 5.1 ES (X86_64)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Solaris 6
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Solaris 7
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Solaris 8
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Solaris 9
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
Solaris 10
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
IBM AIX 4.3.3 (X86)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
IBM AIX 5.1.0 (X86)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
IBM AIX 5.1.0 (X86_64)
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
IBM AIX 5L 5.2
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
IBM AIX 5L 5.3
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Added Image Added
Image Removed Image Removed
IBM AIX 6.1
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
Image Removed Image Removed
 
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


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
Discontinued or not approved by the manufacturer and supported by TOTVS.
Discontinued or not approved by the manufacturer and by TOTVS.
In process of discontinuation by the manufacturer and supported by TOTVS.
Approved by the manufacturer.
Approved by the manufacturer and by TOTVS.
O.S.Informix 7.31Informix 9.21Informix 9.30Informix 9.40Informix 10Informix 11.5
Windows 2000 Server
Windows 2003 (X86)
Windows 2003 (X86_64)
Windows 2008 (X86)
Windows 2008 (X86_64)
Suse SLES8 (X86)
Suse SLES8 (X86_64)
Suse SLES8 (Itanium)
Suse SLES9 (X86)
Suse SLES9 (X86_64)
Suse SLES10 (X86)
Suse SLES10 (X86_64)
RedHat 2.1 AS / ES (X86)
RedHat 2.1 AS / ES (X86_64)
RedHat 2.1 AS / ES (Itanium)
RedHat 3 ES (X86)
RedHat 3 ES (X86_64)
RedHat 3 ES (Itanium)
RedHat 4.6 ES (X86)
RedHat 4.6 ES (X86_64)
RedHat 5.1 ES (X86)
RedHat 5.1 ES (X86_64)
Solaris 6
Solaris 7
Solaris 8
Solaris 9
Solaris 10
IBM AIX 4.3.3 (X86)
IBM AIX 5.1.0 (X86)
IBM AIX 5.1.0 (X86_64)
IBM AIX 5L 5.2
IBM AIX 5L 5.3
IBM AIX 6.1