informix环境变量_DBA_Regan_新浪博客

今天客户新安装的环境在使用时报错：

Program stopped at "tb4_main.4gl", line number 78.
FORMS statement error number -1170.
The type of your terminal is unknown to the system.--根据这段信息找到可能为环境变量问题。

配置好对应的环境变量后正常使用：

TERMCAP=$INFORMIXDIR/etc/termcap export TERMCAP

当4gl和数据库软件安装在同一台服务器时，需要安装在不同的目录中。如下：

echo " 1. DATABASE ADMIN - version11 "

echo " 2. SQL 4GL - version7"

echo "please enter your choice: \c"

read CHOICE

case $CHOICE in

'1') INFORMIXDIR=/home/informix

PATH=$INFORMIXDIR/bin:$INFORMIXDIR/lib:/usr/java/jre1.7.0/bin:$PATH: ;;

'2') INFORMIXDIR=/home/informix/4gl LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$INFORMIXDIR/lib/tools export LD_LIBRARY_PATH PATH=$INFORMIXDIR/bin:$INFORMIXDIR/lib:$PATH;; HOME=/home/informix export HOME cd $HOME

;;

*) echo "choice has to be 1 or 2, please retry"

sleep 3

exit

;;

esac

clear

INFORMIXSERVER=ontest

ONCONFIG=onconfig.ontest INFORMIXSQLHOSTS=/home/informix/etc/sqlhosts PATH=$PATH:$INFORMIXDIR/bin:$PATH:/home/informix/4gl/bin:$PATH:/home/informix/4gl/lib export INFORMIXSERVER INFORMIXDIR ONCONFIG PATH INFORMIXSQLHOSTS

DBDATE=MDY4/

export DBDATE

TERMCAP=$INFORMIXDIR/etc/termcap

export TERMCAP