Cannot set/unset DELIMIDENT
Posted in 2004
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues
Solaris 8
Informix Dynamic Server Version 7.31.FD1
On the specific server commands in dbaccess behave as if DELIMIDENT is
set. Neither does it show when I list the current environment
variables nor can I unset it. I have tried it in Kourne shell as well
as Cshell with no effect. (I have tested the set and unset of
DELIMIDENT on two other servers with the same software loaded and
there it is working as desribed in the manual) The servers are all
running SAP 4.6.
The output of "env" is:
--------------------------------------------------------------------------------
HOME=/export/home/informix
PATH=/informix/PRD/bin:/export/home/informix:/usr/sap/PRD/SYS/exe/run:/bin:/usr/bin:/usr/ucb:/etc:/usr/local/bin:/usr/local/sbin:.:/usr/ccs/binLOGNAME=informix
HZ=100
TERM=sun
TZ=GMT-2
SHELL=/bin/csh
MAIL=/var/mail/informix
PWD=/export/home/informix
USER=informix
DMS_PATH=/opt/CA/dmscript
DBEDIT=vi
NSR_DATA_VOLUME_POOL=DBMIData
NSR_LOG_VOLUME_POOL=DBMILogs
INFORMIXTERM=terminfoEDITOR=vi
SAPSYSTEMNAME=PRD
DIR_LIBRARY=/usr/sap/PRD/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/PRD/SYS/exe/run:/informix/PRD/lib:/informix/PRD/lib/esqlINFORMIX_DBID=prd
INFORMIXDIR=/informix/PRD
ONCONFIG=onconfig.gariep.prdDBBLOBBUF=64
INFMXLOGS=30
SQLSTATS=2
SAPDBA_RAWDEVS=/informix/PRD
DBDATE=mdy2/TERMCAP=/informix/PRD/etc/termcap
INFORMIXSHMBASE=0x01000000LC_CTYPE=iso_8859_1
INFORMIXSQLHOSTS=/informix/PRD/etc/sqlhosts.tli
INFORMIXSERVER=gariepprdshmdbms_type=inf
-------------------------------------------------------------------------------
Although DELIMIDENT is not set it behaves as if it is set.
Please help -- We have to unset DELIMIDENT.
Regards
Petro