Interstage Navigator ServerV9.6.0 DBレスシステム構築ガイド

D.2.2 出力例

アクセスログの出力例を示します。

正常時の出力例

[DATE] 2008-03-31 09:25:04
[USERNAME] naviuser1
[CLIENT] ***.***.***.***
[P-ID] 3384
[SELECT STATEMENT]SELECT SUM(JVRX.NUMBERS),JVRX01.NMGOODS FROM CSVFILE.売上明細 JVRX,CSVFILE.商品マスタ JVRX01 WHERE JVRX01.GOODSNO=JVRX.GOODSNO GROUP BY JVRX01.NMGOODS ORDER BY
2 ASC
[FILE TYPE] CSV
[FILE LIST] C:\NAVI\DATA\M01GOODS.csvC:\NAVI\DATA\T01SALES.csv
[OPEN START] 2008-03-31 09:25:03.781

[OPEN END] 2008-03-31 09:25:04.062
[FETCH1] 2008-03-31 09:25:04.218
[FETCH2] 2008-03-31 09:25:04.218
[FETCH TIME1] 437
[FETCH TIME2] 0
[NUMBER OF ROWS] 51

異常時の出力例

[DATE] 2008-03-31 09:46:59
[USERNAME] naviuser1
[CLIENT] ***.***.***.***
[P-ID] 3384
[SELECT STATEMENT]SELECT SUM(JVRX.EMPNUMBER),JVRX.KENMEI,JVRX.NMTENPO FROM CSVFILE.店舗マスタ JVRX GROUP BY JVRX.KENMEI,JVRX.NMTENPO ORDER BY 2 ASC , 3 ASC
[OPEN START] 2008-03-31 09:46:59.859
[OPEN END] 2008-03-31 09:46:59.953
[NUMBER OF ROWS] 0
[ERROR] KVR71751 指定の入力ファイルが存在しません(ファイル名:d:\navi\CSV\M02MAKER42.csv)。