- 论坛徽章:
- 0
|
[08/01/23 17:06:07]
UPDATE c23.CD_HONBU_SYONIN_LEVEL RSN SET ( RSN.ZYOSIN_KIZYUNZAN_YEN ) = ( SELECT KOB.ZYOSIN_KIZYUNZAN_YEN FROM ck.CD_HONBU_SYONIN_LEVEL KOB WHERE KOB.SAIMUSYA_CD = RSN.SAIMUSYA_CD AND KOB.HONBU_SYONIN_LEVEL_NO = RSN.HONBU_SYONIN_LEVEL_NO ) WHERE EXISTS ( SELECT 1 FROM ck.CD_HONBU_SYONIN_LEVEL KOB WHERE KOB.SAIMUSYA_CD = RSN.SAIMUSYA_CD AND KOB.HONBU_SYONIN_LEVEL_NO = RSN.HONBU_SYONIN_LEVEL_NO )
SQLCA 情報 sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQL08020 sqlerrd : (1) 0 (2) 0 (3) 7 (4) 0 (5) 0 (6) 0 sqlwarn : (1) (2) (3) (4) (5) (6) (7) ( (9) (10) (11) sqlstate: 00000
更新件数[7]。
[08/01/23 17:06:11]
UPDATE c23.CD_KIZITU RSN SET ( TYUSYUTU_MM_CNT , YUKO_MM_CNT , KIZITU_KIZYUNZAN_YEN ) = ( SELECT TYUSYUTU_MM_CNT , YUKO_MM_CNT , KIZITU_KIZYUNZAN_YEN FROM ck.CD_KIZITU KOB WHERE RSN.KIZITU_CD = KOB.KIZITU_CD AND RSN.KIZITU_SUB_CD = KOB.KIZITU_SUB_CD ) WHERE EXISTS ( SELECT 1 FROM ck.CD_KIZITU KOB WHERE RSN.KIZITU_CD = KOB.KIZITU_CD AND RSN.KIZITU_SUB_CD = KOB.KIZITU_SUB_CD )
SQLCA 情報 sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQL08020 sqlerrd : (1) 0 (2) 0 (3) 2 (4) 0 (5) 0 (6) 0 sqlwarn : (1) (2) (3) (4) (5) (6) (7) ( (9) (10) (11) sqlstate: 00000
更新件数[2]。
[08/01/23 17:06:16]
UPDATE c23.CD_SAIMUSYA RSN SET (KANSA_KIZYUNZAN_YEN,KANSA_KIZYUN_SAIKEN_ZAN_YEN,SYONIN_KIZYUNZAN_YEN) = ( SELECT KANSA_KIZYUNZAN_YEN,KANSA_KIZYUN_SAIKEN_ZAN_YEN,SYONIN_KIZYUNZAN_YEN FROM ck.CD_SAIMUSYA KOB WHERE KOB.SAIMUSYA_CD = RSN.SAIMUSYA_CD ) WHERE EXISTS ( SELECT 1 FROM ck.CD_SAIMUSYA KOB WHERE KOB.SAIMUSYA_CD = RSN.SAIMUSYA_CD )
SQLCA 情報 sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQL08020 sqlerrd : (1) 0 (2) 0 (3) 8 (4) 0 (5) 0 (6) 0 sqlwarn : (1) (2) (3) (4) (5) (6) (7) ( (9) (10) (11) sqlstate: 00000
更新件数[8]。
[08/01/23 17:06:19]
UPDATE c23.CD_TRIGGER RSN SET TRIGGER_KIZYUNZAN_YEN = ( SELECT TRIGGER_KIZYUNZAN_YEN FROM ck.CD_TRIGGER KOB WHERE KOB.TRIGGER_CD = RSN.TRIGGER_CD ) WHERE EXISTS ( SELECT 1 FROM ck.CD_TRIGGER KOB WHERE KOB.TRIGGER_CD = RSN.TRIGGER_CD )
SQLCA 情報 sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQL08020 sqlerrd : (1) 0 (2) 0 (3) 21 (4) 0 (5) 0 (6) 0 sqlwarn : (1) (2) (3) (4) (5) (6) (7) ( (9) (10) (11) sqlstate: 00000
更新件数[21]。
[08/01/23 17:06:21]
UPDATE c23.CD_TYUSYUTU_SYOSAI RSN SET ( RSN.HANTEI_KIZYUN_VAL, RSN.KIZYUN_YOSINZAN_YEN, RSN.KIZYUN_YOSINZAN2_YEN, RSN.KIZYUN_YOSINZAN3_YEN, RSN.KIZYUN_YOSINSOGAKU_YEN ) = ( SELECT KOB.HANTEI_KIZYUN_VAL, KOB.KIZYUN_YOSINZAN_YEN, KOB.KIZYUN_YOSINZAN2_YEN, KOB.KIZYUN_YOSINZAN3_YEN, KOB.KIZYUN_YOSINSOGAKU_YEN FROM ck.CD_TYUSYUTU_SYOSAI KOB WHERE KOB.TYUSYUTU_CD = RSN.TYUSYUTU_CD AND KOB.TYUSYUTU_SUB_CD = RSN.TYUSYUTU_SUB_CD ) WHERE EXISTS ( SELECT 1 FROM ck.CD_TYUSYUTU_SYOSAI KOB WHERE KOB.TYUSYUTU_CD = RSN.TYUSYUTU_CD AND KOB.TYUSYUTU_SUB_CD = RSN.TYUSYUTU_SUB_CD )
SQLCA 情報 sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQL08020 sqlerrd : (1) 0 (2) 0 (3) 63 (4) 0 (5) 0 (6) 0 sqlwarn : (1) (2) (3) (4) (5) (6) (7) ( (9) (10) (11) sqlstate: 00000
更新件数[63]。
[08/01/23 17:06:25]
SELECT COUNT(1) CNT FROM c23.CD_HONBU_SYONIN_LEVEL RSN,ck.CD_HONBU_SYONIN_LEVEL KOB WHERE RSN.SAIMUSYA_CD = KOB.SAIMUSYA_CD AND RSN.HONBU_SYONIN_LEVEL_NO = KOB.HONBU_SYONIN_LEVEL_NO AND RSN.ZYOSIN_KIZYUNZAN_YEN = KOB.ZYOSIN_KIZYUNZAN_YEN
CNT ----------- 7 1 。 SQLCA 情報 sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQLRI01F sqlerrd : (1) -2147221503 (2) 1 (3) 0 (4) 0 (5) 0 (6) 0 sqlwarn : (1) (2) (3) (4) (5) (6) (7) ( (9) (10) (11) sqlstate: 00000
[08/01/23 17:06:48]
SELECT COUNT(1) CNT FROM c23.CD_KIZITU RSN,ck.CD_KIZITU KOB WHERE RSN.KIZITU_CD = KOB.KIZITU_CD AND RSN.KIZITU_SUB_CD = KOB.KIZITU_SUB_CD AND RSN.TYUSYUTU_MM_CNT = KOB.TYUSYUTU_MM_CNT AND RSN.YUKO_MM_CNT = KOB.YUKO_MM_CNT AND RSN.KIZITU_KIZYUNZAN_YEN = KOB.KIZITU_KIZYUNZAN_YEN
CNT ----------- 2 1 。 SQLCA 情報 sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQLRI01F sqlerrd : (1) -2147221503 (2) 1 (3) 0 (4) 0 (5) 0 (6) 0 sqlwarn : (1) (2) (3) (4) (5) (6) (7) ( (9) (10) (11) sqlstate: 00000
[08/01/23 17:06:53]
SELECT COUNT(1) CNT FROM c23.CD_SAIMUSYA RSN,ck.CD_SAIMUSYA KOB WHERE RSN.SAIMUSYA_CD = KOB.SAIMUSYA_CD AND RSN.KANSA_KIZYUNZAN_YEN = KOB.KANSA_KIZYUNZAN_YEN AND RSN.KANSA_KIZYUN_SAIKEN_ZAN_YEN = KOB.KANSA_KIZYUN_SAIKEN_ZAN_YEN AND RSN.SYONIN_KIZYUNZAN_YEN = KOB.SYONIN_KIZYUNZAN_YEN
CNT ----------- 8 1 。 SQLCA 情報 sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQLRI01F sqlerrd : (1) -2147221503 (2) 1 (3) 0 (4) 0 (5) 0 (6) 0 sqlwarn : (1) (2) (3) (4) (5) (6) (7) ( (9) (10) (11) sqlstate: 00000
[08/01/23 17:06:57]
SELECT COUNT(1) CNT FROM c23.CD_TRIGGER RSN,ck.CD_TRIGGER KOB WHERE RSN.TRIGGER_CD = KOB.TRIGGER_CD AND RSN.TRIGGER_KIZYUNZAN_YEN = KOB.TRIGGER_KIZYUNZAN_YEN
CNT ----------- 21 1 。 SQLCA 情報 sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQLRI01F sqlerrd : (1) -2147221503 (2) 1 (3) 0 (4) 0 (5) 0 (6) 0 sqlwarn : (1) (2) (3) (4) (5) (6) (7) ( (9) (10) (11) sqlstate: 00000
[08/01/23 17:07:00]
SELECT COUNT(1) CNT FROM c23.CD_TYUSYUTU_SYOSAI RSN,ck.CD_TYUSYUTU_SYOSAI KOB WHERE RSN.TYUSYUTU_CD = KOB.TYUSYUTU_CD AND RSN.TYUSYUTU_SUB_CD = KOB.TYUSYUTU_SUB_CD AND RSN.HANTEI_KIZYUN_VAL = KOB.HANTEI_KIZYUN_VAL AND RSN.KIZYUN_YOSINZAN_YEN = KOB.KIZYUN_YOSINZAN_YEN AND RSN.KIZYUN_YOSINZAN2_YEN = KOB.KIZYUN_YOSINZAN2_YEN AND RSN.KIZYUN_YOSINZAN3_YEN = KOB.KIZYUN_YOSINZAN3_YEN AND RSN.KIZYUN_YOSINSOGAKU_YEN = KOB.KIZYUN_YOSINSOGAKU_YEN
CNT ----------- 63 1 。 SQLCA 情報 sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQLRI01F sqlerrd : (1) -2147221503 (2) 1 (3) 0 (4) 0 (5) 0 (6) 0 sqlwarn : (1) (2) (3) (4) (5) (6) (7) ( (9) (10) (11) sqlstate: 00000
应ly5066113 的要求贴的LOG内容.
先做的更新,后按更新条件做的查询. |
|