bcpout

UNIX/LINUX平台下面SMS网管原代码

#!/bin/sh
SYBASE="/sybclt"
export SYBASE

SYBASE_OCS="OCS-12_5"
export SYBASE_OCS

PATH="/sybclt/OCS-12_5/bin":.:$PATH:$HOME/bin
export PATH

LIBPATH="/sybclt/OCS-12_5/lib:/sybclt/OCS-12_5/lib3p":$LIBPATH
export LIBPATH

SYBASE_JRE="/sybclt/shared-1_0/JRE-1_3"
export SYBASE_JRE

DSQUERY=nbcc
export DSQUERY

bcp ccbdb..acl_ag_grp              out  acl_ag_grp.unl 		-c -Snbcc -Uagent -Pabc123               
bcp ccbdb..acl_ag_pos              out  acl_ag_pos.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..acl_func                out  acl_func.unl                -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..acl_o_r_map             out  acl_o_r_map.unl             -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..acl_oper                out  acl_oper.unl                -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..acl_org                 out  acl_org.unl                 -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..acl_r_f_map             out  acl_r_f_map.unl             -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..acl_role                out  acl_role.unl                -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..acl_role_grp            out  acl_role_grp.unl            -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..after_agent             out  after_agent.unl             -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..after_mon_record        out  after_mon_record.unl        -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..after_monitor_rec       out  after_monitor_rec.unl       -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..after_msitochannel      out  after_msitochannel.unl      -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..after_name_list         out  after_name_list.unl         -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..after_praise_data       out  after_praise_data.unl       -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..after_result_list       out  after_result_list.unl       -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..after_svc_play          out  after_svc_play.unl          -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..after_trade_cn          out  after_trade_cn.unl          -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..after_yufang_data       out  after_yufang_data.unl       -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..afterconfig             out  afterconfig.unl             -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..atm_info                out  atm_info.unl                -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..branch                  out  branch.unl                  -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..branch_infowh           out  branch_infowh.unl           -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..branch_unit             out  branch_unit.unl             -c -Snbcc -Uagent -Pabc123       
bcp ccbdb..busi_price_info         out  busi_price_info.unl         -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..card_city_info          out  card_city_info.unl          -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..cbis_typ                out  cbis_typ.unl                -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..CFIS_FND                out  CFIS_FND.unl                -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..ciscfg                  out  ciscfg.unl                  -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..cityinfo                out  cityinfo.unl                -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..co_acc_reg              out  co_acc_reg.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..co_boacc_def            out  co_boacc_def.unl            -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..co_broker_info          out  co_broker_info.unl          -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..co_broker_passinfo      out  co_broker_passinfo.unl      -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..co_info                 out  co_info.unl                 -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..co_keyinfo              out  co_keyinfo.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..co_obacc_reg            out  co_obacc_reg.unl            -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..co_pay_fee              out  co_pay_fee.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..co_updateinfo           out  co_updateinfo.unl           -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..consign                 out  consign.unl                 -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..currency_code           out  currency_code.unl           -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..currency_type           out  currency_type.unl           -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..cust_clas               out  cust_clas.unl               -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..cust_outbandinfo        out  cust_outbandinfo.unl        -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..cust_phoneinfo          out  cust_phoneinfo.unl          -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..daily_switch_ctl        out  daily_switch_ctl.unl        -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..daily_txlog1            out  daily_txlog1.unl            -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..daily_txlog2            out  daily_txlog2.unl            -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..dept_info               out  dept_info.unl               -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..dttest                  out  dttest.unl                  -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..erp                     out  erp.unl                     -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..exchg_rate              out  exchg_rate.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..fee_rate                out  fee_rate.unl                -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..flowblist               out  flowblist.unl               -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..flowevent               out  flowevent.unl               -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..flowgjinfo              out  flowgjinfo.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..flowhandle              out  flowhandle.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..flowhandlehis           out  flowhandlehis.unl           -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..flownotes               out  flownotes.unl               -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..hautotree               out  hautotree.unl               -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..holiday                 out  holiday.unl                 -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..htm_table_info          out  htm_table_info.unl          -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..intr_rate               out  intr_rate.unl               -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..intre_rate              out  intre_rate.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..item_info               out  item_info.unl               -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..logoperation            out  logoperation.unl            -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..operator_reg            out  operator_reg.unl            -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..other_info              out  other_info.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..pbcatcol                out  pbcatcol.unl                -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..person_info             out  person_info.unl             -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..prompt_info             out  prompt_info.unl             -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..ps_acc_reg              out  ps_acc_reg.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..ps_accinfo              out  ps_accinfo.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..ps_acct_link            out  ps_acct_link.unl            -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..ps_keyinfo              out  ps_keyinfo.unl              -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..ps_obacc_reg            out  ps_obacc_reg.unl            -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..ps_proxyauth            out  ps_proxyauth.unl            -c -Snbcc -Uagent -Pabc123     
bcp ccbdb..ps_relinfo              out  ps_relinfo.unl              -c -Snbcc -Uagent -Pabc123