Omron NX701-1620

6 How to Use Operation Logs
6-17
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
6
6-3 Debug Log
6-3-7 Debug Log File Specifications
*4 Log Name
Category
Operation
Log name
DB Connection
DB Connection Established
Connect
SQL
INSERT
INSERT
UPDATE
UPDATE
SELECT
SELECT
DELETE
DELETE
SQL Execution
Result
INSERT
INSERT
UPDATE
UPDATE
SELECT
SELECT
DELETE
DELETE
User-specified Log DB_PutLog Instruction Executed Text string specified in the LogName
input variable of the DB_PutLog
instruction.
Log file example:
1 2012-07-24 09:00:00 150 SQL 0001 INSERT 0x0000 MyDatabase1 45 TABLE_Production Production
INSERT INTO TABLE_Production(Column1) VALUES(‘1000’)”
2 2012-07-24 09:00:00 200 SQL_RESULT 0001 INSERT 0x300B MyDatabase1 46 17072 ORA-17072: Inserted value
too large for column
Precautions for Correct Use
Do not delete the latest log file (DB_DebugLog.log) and the log control file
(DB_DebugLog.fjc) from the SD Memory Card. If they are deleted, the log files are not
saved correctly, for example, the Debug Log data are lost.