Export/Import

Export

 

1. db2 connect to ivsdb user yuser using `cat /dwedw/pwd/yuser_pwd.txt`
   db2 "export to /dwmallusr/yuser/data/yrg/af/YERT_CASH_FLOW_DETL_$4.txt of del MODIFIED BY NOCHARDEL STRIPLZEROS DECPLUSBLANK COLDEL, \
        messages /dwmallusr/yuser/log/yrg/af/YERT_CASH_FLOW_DETL_$4.exp  \
        SELECT *                         \
          FROM YUSER.YERT_CASH_FLOW_DETL \
         WHERE 1 = 1                     \
           AND DEAL_STND_DAY = '$4'      \
          WITH UR"

 

Import

 

1. db2 import from import.file of ixf messages msg.imp insert into 테이블명

이 글은 스프링노트에서 작성되었습니다.