sheell 中 informix与oracle操作数据库解读

sqlplus -S ${DBUSER}/${DBPWD}@${DBNAME}  >> $dblogfile 2>&1 <<!
@${loadsubdir}bus_cresystbl_ora.sql;
exit;
!



       dbaccess $SYSDB ${loadsubdir}bus_cresystbl_inf.sql >> $dblogfile 2>&1






   dbaccess $SYSDB - >> $dblogfile 2>&1 <<EOF
		delete from CurrencyType ;
    EOF






	dbaccess $dbName - - >> $dblogfile 2>&1 << EOF	
		load from $dataFile insert into $table;
          EOF
















[code ="unl"]http://linux.sheup.com/linuxs/list_5_1.htm