"Ksh db2 insert sql result"의 두 판 사이의 차이
DB CAFE
| 4번째 줄: | 4번째 줄: | ||
echo $V_COUNT | echo $V_COUNT | ||
| + | </source> | ||
| + | |||
| + | 전체 | ||
| + | |||
| + | <source> | ||
| + | #!/bin/ksh | ||
| + | |||
| + | if [ ${#} -ne 3 ] | ||
| + | then | ||
| + | echo "use parameter :ex) ./SH_SUBUL_JOB.ksh JOBNAME SRC_TABLE day_list_2018.txt" | ||
| + | exit 255 | ||
| + | fi | ||
| + | |||
| + | echo "dw subl db $1 $2 $3 converting..." | ||
| + | |||
| + | HOME=/home/mig_adm | ||
| + | |||
| + | DR='_' | ||
| + | JBNAME=$1 | ||
| + | TBNAME=$2 | ||
| + | DAY_TXT=$3 | ||
| + | |||
| + | funcall () { | ||
| + | |||
| + | echo Z#$TBNAME | ||
| + | |||
| + | cat $HOME/CYKIM/$DAY_TXT | while read var ; do db2 -v connect to mgsdw user mig_adm using cslee1234; db2 "CALL MIG_ADM.MP0_JOB_SWITCH_ON('$JBNAME','Z#$TBNAME$DR$var');"; db2 -mvf $HOME/CYKIM/Z#$TBNAME$DR$var.SQL |grep "Number o | ||
| + | f rows affected" |awk '{print $6}' | read V_COUNT;db2 "INSERT INTO MIG_ADM.MIG_SUBL_LOG (JOBNAME,TABLE_NAME,TGT_TABLE_NAME,PART_DT,INS_ROWS) VALUES ('$JBNAME','$TBNAME','Z#$TBNAME$DR$var','$var','$V_COUNT')"; db2 "CALL MIG_ADM. | ||
| + | MP0_JOB_SWITCH_OFF('$JBNAME','Z#$TBNAME$DR$var');"; done | ||
| + | |||
| + | echo "job completed..." | ||
| + | } | ||
| + | |||
| + | fork () { | ||
| + | funcall & | ||
| + | } | ||
| + | |||
| + | fork | ||
| + | child_pid="$!" | ||
| + | wait "$child_pid" | ||
| + | |||
</source> | </source> | ||
2018년 10월 16일 (화) 22:18 판
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
건수 처리
db2 -m "insert into test values(1)" | grep "Number of rows affected" |awk '{print $6}' | read V_COUNT
echo $V_COUNT전체
#!/bin/ksh
if [ ${#} -ne 3 ]
then
echo "use parameter :ex) ./SH_SUBUL_JOB.ksh JOBNAME SRC_TABLE day_list_2018.txt"
exit 255
fi
echo "dw subl db $1 $2 $3 converting..."
HOME=/home/mig_adm
DR='_'
JBNAME=$1
TBNAME=$2
DAY_TXT=$3
funcall () {
echo Z#$TBNAME
cat $HOME/CYKIM/$DAY_TXT | while read var ; do db2 -v connect to mgsdw user mig_adm using cslee1234; db2 "CALL MIG_ADM.MP0_JOB_SWITCH_ON('$JBNAME','Z#$TBNAME$DR$var');"; db2 -mvf $HOME/CYKIM/Z#$TBNAME$DR$var.SQL |grep "Number o
f rows affected" |awk '{print $6}' | read V_COUNT;db2 "INSERT INTO MIG_ADM.MIG_SUBL_LOG (JOBNAME,TABLE_NAME,TGT_TABLE_NAME,PART_DT,INS_ROWS) VALUES ('$JBNAME','$TBNAME','Z#$TBNAME$DR$var','$var','$V_COUNT')"; db2 "CALL MIG_ADM.
MP0_JOB_SWITCH_OFF('$JBNAME','Z#$TBNAME$DR$var');"; done
echo "job completed..."
}
fork () {
funcall &
}
fork
child_pid="$!"
wait "$child_pid"