Get and set Informix® connection properties

The following methods are defined in the extended DataSource interface for getting and setting HCL Informix® environment variable values.

Note: Support for Communication Support Module (CSM) is removed starting Informix Server 14.10.xC9 . You should use Transport Layer Security (TLS)/Secure Sockets Layer (SSL) instead.


Environment variable	getIfxXXX() and setIfxXXX() method signatures
CLIENT_LOCALE	public String getIfxCLIENT_LOCALE() public void setIfxCLIENT_LOCALE(String value)
CSM	public String getIfxCSM() public void setIfxCSM(String csm)
DBANSIWARN	public boolean isIfxDBANSIWARN() public void setIfxDBANSIWARN(boolean value)
DBCENTURY	public String getIfxDBCENTURY() public void setIfxDBCENTURY(String value)
DBDATE	public String getIfxDBDATE() public void setIfxDBDATE(String value)
DB_LOCALE	public String getIfxDB_LOCALE() public void setIfxDB_LOCALE(String value)
DBSPACETEMP	public String getIfxDBSPACETEMP() public void setIfxDBSPACETEMP(String value)
DBTEMP	public String getIfxDBTEMP() public void setIfxDBTEMP(String value)
DBUPSPACE	public String getIfxDBUPSPACE() public void setIfxDBUPSPACE(String value)
DELIMIDENT	public boolean isIfxDELIMIDENT() public void setIfxDELIMIDENT(boolean value)
ENABLE_TYPE_CACHE	public boolean isIfxENABLE_TYPE_CACHE() public void setIfxENABLE_TYPE_CACHE(boolean value)
ENABLE_HDRSWITCH	public booleangetIfxENABLE_HDRSWITCH() public void setIfxENABLE_HDRSWITCH(boolean value)
FET_BUF_SIZE	public int getIfxFET_BUF_SIZE() public void setIfxFET_BUF_SIZE(int value)
GL_DATE	public String getIfxGL_DATE() public void setIfxGL_DATE(String value)
IFX_AUTOFREE	public boolean isIfxIFX_AUTOFREE() public void setIfxIFX_AUTOFREE(boolean value)
IFX_CODESETLOB	public int getIfxIFX_CODESETLOB() public void setIfxIFX_CODESETLOB(int codesetlobFlag)
IFX_DIRECTIVES	public String getIfxIFX_DIRECTIVES() public void setIfxIFX_DIRECTIVES(String value)
IFX_EXTDIRECTIVES	public String getIfxIFX_EXTDIRECTIVES() public void setIfxIFX_EXTDIRECTIVES(String value)
IFX_FLAT_UCSQ	public int getIfxIFX_FLAT_UCSQ() public void setIfxIFX_FLAT_UCSQ(int value)
IFX_GET_SMFLOAT_AS_FLOAT	public boolean getIfxIFX_GET_SMFLOAT_AS_FLOAT() public void setIfxIFX_IFX_GET_SMFLOAT_AS_FLOAT(boolean value)
IFX_ISOLATION_LEVEL	public String getIfxIFX_ISOLATION_LEVEL() public void setIfxIFX_ISOLATION_LEVEL (String iso_level)
IFX_LOCK_MODE_WAIT	public int getIfxIFX_LOCK_MODE_WAIT() public void setIfxIFX_LOCK_MODE_WAIT(int lock_time)
IFX_SET_FLOAT_AS_SMFLOAT	public boolean getIfxIFX_SET_FLOAT_AS_SMFLOAT() public void setIfxIFX_SET_FLOAT_AS_SMFLOAT(boolean value)
IFX_SOC_KEEPALIVE	public void setIfxIFX_SOC_KEEPALIVE(boolean keepalive) public boolean getIfxIFX_SOC_KEEPALIVE()
IFX_TRIMTRAILINGSPACES	public int getIfxIFX_TRIMTRAILINGSPACES() public void setIfxIFX_TRIMTRAILINGSPACES(int value)
IFXHOST	public String getIfxIFXHOST() public void setIfxIFXHOST(String value)
IFXHOST_SECONDARY	public String getIfxIFXHOST_SECONDARY() public void setIfxIFXHOST_SECONDARY(String value)
IFX_USEPUT	public boolean isIfxIFX_USEPUT() public void setIfxIFX_USEPUT(boolean value)
IFX_XASPEC	public String getIfxIFX_XASPEC() (returns `y` or `n`) public void IfxIFX_XASPEC(String XASPEC_flag) (only `y`, `Y`, `n`, or `N` are valid)
IFX_XASTDCOMPLIANCE_XAEND	public int getIfxIFX_XASTDCOMPLIANCE_XAEND() public void setIfxIFX_XASTDCOMPLIANCE_XAEND(int value)
INFORMIXCONRETRY	public int getIfxINFORMIXCONRETRY() public void setIfxINFORMIXCONRETRY(int value)
INFORMIXCONTIME	public int getIfxINFORMIXCONTIME() public void setIfxINFORMIXCONTIME(int value)
INFORMIXOPCACHE	public String getIfxINFORMIXOPCACHE() public void setIfxINFORMIXOPCACHE(String value)
INFORMIXSERVER_SECONDARY	public String getIfxINFORMIXSERVER_SECONDARY() public void setIfxINFORMIXSERVER_SECONDARY(String value)
INFORMIXSTACKSIZE	public int getIfxINFORMIXSTACKSIZE() public void setIfxINFORMIXSTACKSIZE(int value)
JDBCTEMP	public String getIfxJDBCTEMP() public void setIfxJDBCTEMP(String value)
LDAP_IFXBASE	public String getIfxLDAP_IFXBASE() public void setIfxLDAP_IFXBASE(String value)
LDAP_PASSWD	public String getIfxLDAP_PASSWD() public void setIfxLDAP_PASSWD(String value)
LDAP_URL	public String getIfxLDAP_URL() public void setIfxLDAP_URL(String value)
LDAP_USER	public String getIfxLDAP_USER() public void setIfxLDAP_USER(String value)
LOBCACHE	public int getIfxLOBCACHE() public void setIfxLOBCACHE(int value)
NEWCODESET	public String getIfxNEWCODESET() public void setIfxNEWCODESET(String value)
NEWLOCALE	public String getIfxNEWLOCALE() public void setIfxNEWLOCALE(String value)
NEWNLSMAP	public String getIfxNEWNLSMAP() public void setIfxNEWNLSMAP(String value)
NODEFDAC	public String getIfxNODEFDAC() public void setIfxNODEFDAC(String value)
OPT_GOAL	public String getIfxOPT_GOAL() public void setIfxOPT_GOAL(String value)
OPTCOMPIND	public String getIfxOPTCOMPIND() public void setIfxOPTCOMPIND(String value)
OPTOFC	public String getIfxOPTOFC() public void setIfxOPTOFC(String value)
PATH	public String getIfxPATH() public void setIfxPATH(String value)
PDQPRIORITY	public String getIfxPDQPRIORITY() public void setIfxPDQPRIORITY(String value)
PORTNO_SECONDARY	public String getIfxPORTNO_SECONDARY public void setIfxPORTNO_SECONDARY(int value)
PROXY	public String getIfxPROXY() public void setIfxPROXY(String value)
PSORT_DBTEMP	public String getIfxPSORT_DBTEMP() public void setIfxPSORT_DBTEMP(String value)
PSORT_NPROCS	public String getIfxPSORT_NPROCS() public void setIfxPSORT_NPROCS(String value)
SECURITY	public String getIfxSECURITY() public void setIfxSECURITY(String value)
SQLH_FILE	public String getIfxSQLH_FILE() public void setIfxSQLH_FILE(String value)
SQLH_TYPE	public String getIfxSQLH_TYPE() public void setIfxSQLH_TYPE(String value)
SQLIDEBUG	public String getIfxSQLIDEBUG () public void setIfxSQLIDEBUG (String value)
STMT_CACHE	public String getIfxSTMT_CACHE() public void setIfxSTMT_CACHE(String value)