SQLログnwdlogic
2003-08-25 *11:12:21,642 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT DISTINCT REVISION_ID,BUNRUI_CD,SHUBETU_CD,NWTDDOCMT.DOC_ID AS DOC_ID,DOC_NAME_MNM,FILE_NAME_MNM,FILE_TYPE_MNM,FILE_SIZE_SU,UPDATE_YMD,PROPERTY_1_MNM,PROPERTY_2_MNM,PROPERTY_3_MNM,PROPERTY_4_MNM,PROPERTY_5_MNM,HDN_SHO_CD,PROPERTY_6_MNM,PROPERTY_13_MNM,PROPERTY_14_MNM,PROPERTY_15_MNM,PROPERTY_16_MNM FROM NWTDDOCMT , NWTDDCREF WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD = '503' AND SHUBETU_CD IN ('DA','DB','DC','DD','DE','DF','DG','DH','DI','DJ','DK','DL','DM','DN','DO','DP','DQ','DR','DS','DU','DV','DW','DZ','FA','FB','FC','FZ','TA','TB','TC','TZ') AND (DAICHO_ID = 1429) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID WITH UR
2003-08-25 *11:12:21,701 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT DB_JYOSU_CD,DB_KBT_CD,DB_KUMI_SU,DB_FROM_YMD_DTE,DB_TO_YMD_DTE,DB_TRK_YMD_DTE,DB_UPD_TS,DB_UPD_CNT_SU,DB_UPD_USER_CD,DB_UKO_ITM_SU,DB_DATA_1_ITM,DB_DATA_2_ITM,DB_DATA_3_ITM,DB_DATA_4_ITM,DB_DATA_5_ITM,DB_DATA_6_ITM,DB_DATA_7_ITM,DB_DATA_8_ITM,DB_DATA_9_ITM,DB_DATA_10_ITM,DB_DATA_11_ITM,DB_DATA_12_ITM,DB_DATA_13_ITM,DB_DATA_14_ITM,DB_DATA_15_ITM FROM N5TJJYOSU WHERE DB_JYOSU_CD = 'WD01' AND DB_KUMI_SU =0 AND '00000000' <= DB_TO_YMD_DTE AND '99999999'>= DB_FROM_YMD_DTE ORDER BY DB_JYOSU_CD,DB_KBT_CD,DB_KUMI_SU,DB_FROM_YMD_DTE
2003-08-25 *11:12:21,830 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT DB_JYOSU_CD,DB_KBT_CD,DB_KUMI_SU,DB_FROM_YMD_DTE,DB_TO_YMD_DTE,DB_TRK_YMD_DTE,DB_UPD_TS,DB_UPD_CNT_SU,DB_UPD_USER_CD,DB_UKO_ITM_SU,DB_DATA_1_ITM,DB_DATA_2_ITM,DB_DATA_3_ITM,DB_DATA_4_ITM,DB_DATA_5_ITM,DB_DATA_6_ITM,DB_DATA_7_ITM,DB_DATA_8_ITM,DB_DATA_9_ITM,DB_DATA_10_ITM,DB_DATA_11_ITM,DB_DATA_12_ITM,DB_DATA_13_ITM,DB_DATA_14_ITM,DB_DATA_15_ITM FROM N5TJJYOSU WHERE DB_JYOSU_CD = 'WD02' AND DB_KUMI_SU =0 AND '00000000' <= DB_TO_YMD_DTE AND '99999999'>= DB_FROM_YMD_DTE ORDER BY DB_JYOSU_CD,DB_KBT_CD,DB_KUMI_SU,DB_FROM_YMD_DTE
2003-08-25 *11:12:21,925 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT SHUBETU_CD FROM NWTDDSCVT WHERE DOCTYPE_ID = '31'
2003-08-25 *11:12:21,969 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT COUNT(DISTINCT REVISION_ID) AS CNT FROM NWTDDOCMT , NWTDDCREF WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD ='503' AND SHUBETU_CD IN ('3A') AND (DAICHO_ID = 1430) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID WITH UR
2003-08-25 *11:12:22,006 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT SHUBETU_CD FROM NWTDDSCVT WHERE DOCTYPE_ID = 'D1'
2003-08-25 *11:12:22,112 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT COUNT(DISTINCT REVISION_ID) AS CNT FROM NWTDDOCMT , NWTDDCREF WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD ='503' AND SHUBETU_CD IN ('DA','DB','DC','DD','DE','DF','DG','DH','DI','DJ','DK','DL','DM','DN','DO','DP','DQ','DR','DS','DU','DV','DW','DZ','FA','FB','FC','FZ','TA','TB','TC','TZ') AND (DAICHO_ID = 1430) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID WITH UR
2003-08-25 *11:12:22,234 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT DISTINCT REVISION_ID,BUNRUI_CD,SHUBETU_CD,NWTDDOCMT.DOC_ID AS DOC_ID,DOC_NAME_MNM,FILE_NAME_MNM,FILE_TYPE_MNM,FILE_SIZE_SU,UPDATE_YMD,PROPERTY_1_MNM,PROPERTY_2_MNM,PROPERTY_3_MNM,PROPERTY_4_MNM,PROPERTY_5_MNM,HDN_SHO_CD,PROPERTY_6_MNM,PROPERTY_13_MNM,PROPERTY_14_MNM,PROPERTY_15_MNM,PROPERTY_16_MNM FROM NWTDDOCMT , NWTDDCREF WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD = '503' AND SHUBETU_CD IN ('DA','DB','DC','DD','DE','DF','DG','DH','DI','DJ','DK','DL','DM','DN','DO','DP','DQ','DR','DS','DU','DV','DW','DZ','FA','FB','FC','FZ','TA','TB','TC','TZ') AND (DAICHO_ID = 1430) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID WITH UR
2003-08-25 *11:12:22,288 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT DB_JYOSU_CD,DB_KBT_CD,DB_KUMI_SU,DB_FROM_YMD_DTE,DB_TO_YMD_DTE,DB_TRK_YMD_DTE,DB_UPD_TS,DB_UPD_CNT_SU,DB_UPD_USER_CD,DB_UKO_ITM_SU,DB_DATA_1_ITM,DB_DATA_2_ITM,DB_DATA_3_ITM,DB_DATA_4_ITM,DB_DATA_5_ITM,DB_DATA_6_ITM,DB_DATA_7_ITM,DB_DATA_8_ITM,DB_DATA_9_ITM,DB_DATA_10_ITM,DB_DATA_11_ITM,DB_DATA_12_ITM,DB_DATA_13_ITM,DB_DATA_14_ITM,DB_DATA_15_ITM FROM N5TJJYOSU WHERE DB_JYOSU_CD = 'WD01' AND DB_KUMI_SU =0 AND '00000000' <= DB_TO_YMD_DTE AND '99999999'>= DB_FROM_YMD_DTE ORDER BY DB_JYOSU_CD,DB_KBT_CD,DB_KUMI_SU,DB_FROM_YMD_DTE
2003-08-25 *11:12:22,423 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT DB_JYOSU_CD,DB_KBT_CD,DB_KUMI_SU,DB_FROM_YMD_DTE,DB_TO_YMD_DTE,DB_TRK_YMD_DTE,DB_UPD_TS,DB_UPD_CNT_SU,DB_UPD_USER_CD,DB_UKO_ITM_SU,DB_DATA_1_ITM,DB_DATA_2_ITM,DB_DATA_3_ITM,DB_DATA_4_ITM,DB_DATA_5_ITM,DB_DATA_6_ITM,DB_DATA_7_ITM,DB_DATA_8_ITM,DB_DATA_9_ITM,DB_DATA_10_ITM,DB_DATA_11_ITM,DB_DATA_12_ITM,DB_DATA_13_ITM,DB_DATA_14_ITM,DB_DATA_15_ITM FROM N5TJJYOSU WHERE DB_JYOSU_CD = 'WD02' AND DB_KUMI_SU =0 AND '00000000' <= DB_TO_YMD_DTE AND '99999999'>= DB_FROM_YMD_DTE ORDER BY DB_JYOSU_CD,DB_KBT_CD,DB_KUMI_SU,DB_FROM_YMD_DTE
2003-08-25 *11:12:22,501 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT SHUBETU_CD FROM NWTDDSCVT WHERE DOCTYPE_ID = '31'
2003-08-25 *11:12:22,545 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT COUNT(DISTINCT REVISION_ID) AS CNT FROM NWTDDOCMT , NWTDDCREF WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD ='503' AND SHUBETU_CD IN ('3A') AND (DAICHO_ID = 1431) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID WITH UR
2003-08-25 *11:12:22,580 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT SHUBETU_CD FROM NWTDDSCVT WHERE DOCTYPE_ID = 'D1'
2003-08-25 *11:12:22,691 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT COUNT(DISTINCT REVISION_ID) AS CNT FROM NWTDDOCMT , NWTDDCREF WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD ='503' AND SHUBETU_CD IN ('DA','DB','DC','DD','DE','DF','DG','DH','DI','DJ','DK','DL','DM','DN','DO','DP','DQ','DR','DS','DU','DV','DW','DZ','FA','FB','FC','FZ','TA','TB','TC','TZ') AND (DAICHO_ID = 1431) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID WITH UR
2003-08-25 *11:12:22,813 *ZEUS2 *Zeus2node *8136282 *NYZ00015 *[N] *SELECT DISTINCT REVISION_ID,BUNRUI_CD,SHUBETU_CD,NWTDDOCMT.DOC_ID AS DOC_ID,DOC_NAME_MNM,FILE_NAME_MNM,FILE_TYPE_MNM,FILE_SIZE_SU,UPDATE_YMD,PROPERTY_1_MNM,PROPERTY_2_MNM,PROPERTY_3_MNM,PROPERTY_4_MNM,PROPERTY_5_MNM,HDN_SHO_CD,PROPERTY_6_MNM,PROPERTY_13_MNM,PROPERTY_14_MNM,PROPERTY_15_MNM,PROPERTY_16_MNM FROM NWTDDOCMT , NWTDDCREF WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD = '503' AND SHUBETU_CD IN ('DA','DB','DC','DD','DE','DF','DG','DH','DI','DJ','DK','DL','DM','DN','DO','DP','DQ','DR','DS','DU','DV','DW','DZ','FA','FB','FC','FZ','TA','TB','TC','TZ') AND (DAICHO_ID = 1431) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID WITH UR
SELECT
DB_JYOSU_CD,
DB_KBT_CD,
DB_KUMI_SU,
DB_FROM_YMD_DTE,
DB_TO_YMD_DTE,
DB_TRK_YMD_DTE,
DB_UPD_TS,
DB_UPD_CNT_SU,
DB_UPD_USER_CD,
DB_UKO_ITM_SU,
DB_DATA_1_ITM,
DB_DATA_2_ITM,
DB_DATA_3_ITM,
DB_DATA_4_ITM,
DB_DATA_5_ITM,
DB_DATA_6_ITM,
DB_DATA_7_ITM,
DB_DATA_8_ITM,
DB_DATA_9_ITM,
DB_DATA_10_ITM,
DB_DATA_11_ITM,
DB_DATA_12_ITM,
DB_DATA_13_ITM,
DB_DATA_14_ITM,
DB_DATA_15_ITM
FROM N5TJJYOSU
WHERE DB_JYOSU_CD = 'WD01' AND DB_KUMI_SU =0 AND '00000000'
<= DB_TO_YMD_DTE AND '99999999'>= DB_FROM_YMD_DTE
ORDER BY DB_JYOSU_CD,DB_KBT_CD,DB_KUMI_SU,DB_FROM_YMD_DTE
SELECT COUNT(DISTINCT REVISION_ID) AS CNT FROM NWTDDOCMT , NWTDDCREF
WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD ='503'
AND SHUBETU_CD IN ('3A') AND (DAICHO_ID = 1430) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID WITH UR
SELECT COUNT(DISTINCT REVISION_ID) AS CNT FROM NWTDDOCMT , NWTDDCREF
WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD ='503'
AND SHUBETU_CD IN ('DA','DB','DC','DD','DE','DF','DG','DH','DI','DJ','DK','DL','DM','DN','DO','DP','DQ','DR','DS','DU','DV','DW','DZ','FA','FB','FC','FZ','TA','TB','TC','TZ') AND (DAICHO_ID = 1430) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID WITH UR
GROUP BY CURRENT_FLG,UPDATE_FLG,HDN_SHO_CD,DOC_STS,SHUBETU_CD,DAICHO_ID
CREATE TABLE NWTDDSUM AS(
SELECT COUNT(DISTINCT REVISION_ID)
FROM NWTDDOCMT, NWTDDCREF
WHERE NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID
)
DATA INITIALLY DEFERRED
REFRESH IMMEDIATE
ENABLE QUERY OPTIMIZATION
CREATE TABLE NWTDDSUM(CNT_ALL, CNT) AS(
SELECT COUNT(*), COUNT(DISTINCT REVISION_ID)
FROM NWTDDOCMT, NWTDDCREF
WHERE NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID
)
DATA INITIALLY DEFERRED
REFRESH IMMEDIATE
ENABLE QUERY OPTIMIZATION
CREATE TABLE NWTDDSUM(CNT) AS(
SELECT COUNT(DISTINCT REVISION_ID)
FROM NWTDDOCMT, NWTDDCREF
WHERE NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID
AND CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1
)
DATA INITIALLY DEFERRED
REFRESH IMMEDIATE
ENABLE QUERY OPTIMIZATION
SQL20058N マテリアライズ照会表 "PN00Z01D.NWTDDSUM"
に指定された全選択は無効です。 SQLSTATE=428EC
2003/08/25
ugya@lycos.com