Oracle, informix database environment variable settings and compile

view setenv

environment variable settings

#for oracle database ORACLE_BASE=/rdsys/oracle; export ORACLE_BASE #install path

export ORACLE_HOME=/rdsys/oracle/product/9.2.0ORACLE_SID=longtop; export ORACLE_SID #consistent with the database instance TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN NLS_LANG=american_america.zhs16gbk; export NLS_LANG #oracle character set? ? Not sure, check ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data later; export ORA_NLS33ORA_DB=$ORACLE_HOME/dbs; export ORA_DBCLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/JRE/lib/rt.jar: $ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATHexport ORACLE_USERCODE=jhpt/jhpt@longtop

#for INFORMIX Database INFORMIXDIR=/informix INFORMIXSERVER=app_32 PATH=$INFORMIXDIR/bin:$PATHONCONFIG=onconfig DBDATE =Y4MD #date format export INFORMIXDIR INFORMIXSERVER ONCONFIG PATH DBDATE

INFORMIXTERM=terminfoexport INFORMIXTERM

LIBPATH=/usr/lib:$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$LIBPATHDBPATH=$ INFORMIXDIR/frm: $INFORMIXDIR/dataWORKDBS=becdb #库名export LIBPATH DBPATH WORKDBS

Compile:

#for oracle Database PROC=procUSERID=jhpt/jhptPROCPLSFLAGS=sqlcheck=full \\include=. \\include=$(INCLDIR) \\include=$(ORACLE_HOME)/precomp/public \\include=$(ORACLE_HOME)/rdbms/public \\include=$(ORACLE_HOME)/rdbms/demo \\include=$(ORACLE_HOME)/plsql/Public \\include=$(ORACLE_HOME)/netw Ork/public \\mode=oracle \\lines=yes \\def_sqlcode=yes \\parse=none \\userid=$(USERID)

$(PROC) $(PROCPLSFLAGS) $(PCFLAG) iname=$*.pc The #pc compiler compiles .pc into a .c file and then compiles it into a .o/.so

#for informix database ESQL=esql as follows: $(ESQL) -c $(FILE). Ec #If necessary, take the path -I (uppercase i) ec compiler can directly compile the .ec file into .o intermediate generation.c
zh-CN"],null,[0.97558314],zh-CN"]]]