Histórico da Página

...

Portuguese

Pagetitle

	Informix
	Informix

Informix

INFORMAÇÕES IMPORTANTES

A versão 7.31 teve seu suporte descontinuado pelo fabricante na data 30/09/2009, 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 (independente do S.O.)
Está homologado o CLIENT 2 do Informix.

Procedures 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 - Configuração de ODBC

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, e About ... ). Os pontos importantes destas configurações são:

Environment - Cursor Behavior

Image Removed

Image Added

O valor default para este parâmetro é "0-Close". Este parâmetro define o comportamento do banco com relação ao fechamento automático de cursores ( Queries ) quando efetuado um "commit work" ou "rollback work" em uma transação.

O Protheus 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 - Configuração de ODBC.ini para TOTVSDbAccess

O arquivo .ODBC.INI está localizado no diretório raiz do root (cd /root).

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

[nomeconexao]
Database=
Servername=

CursorBehavior=1

Legenda
Image Removed Image RemovedImage Added Image Added	Descontinuado ou não homologado pelo fabricante e suportado pela TOTVS.
Image Removed Image RemovedImage Added Image Added	Descontinuado ou não homologado pelo fabricante e pela TOTVS.
Image Removed Image RemovedImage Added Image Added	Em processo de descontinuação pelo fabricante e suportado pela TOTVS.
Image Removed Image RemovedImage Added Image Added	Homologado pelo fabricante.
Image Removed Image RemovedImage Added Image Added	Homologado pelo fabricante e pela TOTVS.

S.O.	Informix 7.31	Informix 9.21	Informix 9.30	Informix 9.40	Informix 10	Informix 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 AddedImage 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 Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed

Árvore de páginas

Versões comparadas

Versão antiga 1

Nova versão 2

Chave

Informix