导出数据文件脚本
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'
【推荐】FlashTable:表单开发界的极速跑车,让你的开发效率一路狂飙
【推荐】Flutter适配HarmonyOS 5知识地图,实战解析+高频避坑指南
【推荐】博客园的心动:当一群程序员决定开源共建一个真诚相亲平台
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步