导出数据文件脚本

assess_date=$1
source_sys=$2
logfile=spool.log
##spool参数
date_format='yyyy-mm-dd hh24:mi:ss'
newpage=none
heading=off
feedback=off
termout=off
space=0
pagesize=0
trimout=on
trimspool=on
linesize=2500

filetype=unl
echo "sqlplus -s FDS/FDS<<EOF">>'SPOOL.sh'
        echo "alter session set nls_date_format='"$date_format"';">>'SPOOL.sh'
        echo 'set echo off'>>'SPOOL.sh'
        echo 'set newpage '$newpage>>'SPOOL.sh'
        echo 'set heading '$heading>>'SPOOL.sh'
        echo 'set space '$space>>'SPOOL.sh'
        echo 'set pagesize '$pagesize>>'SPOOL.sh'
        echo 'set termout '$termout>>'SPOOL.sh'
        echo 'set feedback '$feedback>>'SPOOL.sh'
        echo 'set trimout '$trimout>>'SPOOL.sh'
        echo 'set trimspool '$trimspool>>'SPOOL.sh'
        echo "alter session set nls_date_format='"$date_format"';">>'SPOOL.sh'
        echo 'set echo off'>>'SPOOL.sh'
        echo 'set newpage '$newpage>>'SPOOL.sh'
        echo 'set heading '$heading>>'SPOOL.sh'
        echo 'set space '$space>>'SPOOL.sh'
        echo 'set pagesize '$pagesize>>'SPOOL.sh'
        echo 'set termout '$termout>>'SPOOL.sh'
        echo 'set feedback '$feedback>>'SPOOL.sh'
        echo 'set trimout '$trimout>>'SPOOL.sh'
        echo 'set trimspool '$trimspool>>'SPOOL.sh'
        echo 'set linesize '$linesize>>'SPOOL.sh'
        filename=akmzz.$filetype
        echo 'spool '/uprrdbbak/$filename';'>>'SPOOL.sh'
        echo 'whenever sqlerror exit SQL.SQLCODE'>>'SPOOL.sh'
        echo 'SELECT '>>'SPOOL.sh'
        echo "CORPORATION||'|'||FDATE||'|'||GL_TYPE||'|'||GL_SECTION||'|'||FINA_BRANCH||'|'||CCY||'|'||SUBJECT_CODE||'|'||FINA_DATE||'|'||RPT_IN_OUT_FLG||'|'||ACCT_PROPERTY||'|'||SUBJECT_LEVEL||'|'||SUBJECT_NAME||'|'||LAST_CREDIT_BAL||'|'||LAST_DEBIT_BAL||'|'||LAST_ACCTS_NUM||'|'||CREDIT_BAL||'|'||DEBIT_BAL||'|'||ACCTS_NUM||'|'||DEBIT_MULTIPLY_NUM||'|'||CREDIT_MULTIPLY_NUM||'|'||DEBIT_CNT||'|'||CREDIT_CNT||'|'||DEBIT_AMOUNT||'|'||CREDIT_AMOUNT||'|'||OPEN_ACCTS_NUM||'|'||CLOSE_ACCTS_NUM||'|'||CASH_DEBIT_CNT||'|'||CASH_CREDIT_CNT||'|'||CASH_DEBIT_AMOUNT||'|'||CASH_CREDIT_AMOUNT||'|'||TRANSFER_DEBIT_CNT||'|'||TRANSFER_CREDIT_CNT||'|'||TRANSFER_DEBIT_AMOUNT||'|'||TRANSFER_CREDIT_AMOUNT||'|'||MTN_TELLER||'|'||MTN_BRANCH||'|'||MTN_DATE||'|'||RECORD_STATUS">>'SPOOL.sh'
        echo " FROM FDS.GL_SUBJECT_ACCT_ALL WHERE GL_SECTION = '1';">>'SPOOL.sh'
        echo "spool off;">>'SPOOL.sh'
  echo "!">>'SPOOL.sh'

posted @   CoderLeob  阅读(257)  评论(0)    收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示