Omron NX701-1620

6 How to Use Operation Logs
6-16
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
*2 Category
Category
Characters displayed in the log
DB Connection
DB_CONNECTION
SQL
SQL
SQL Execution Result
SQL_RESULT
User-specified Log
USER
*3 Code
Category Code
(decimal)
Operation Log recording timing
DB Connection 0001 DB Connection
Established
When the establishment processing of a DB
Connection is completed (succeeded/failed)
after the establishment is commanded from
the applicable instruction.
SQL 0001 INSERT  Before the DB Connection Service sends
an SQL statement after a DB_Insert (Insert
DB Record) instruction is executed
 When an SQL statement is stored in the
Spool memory
0002 UPDATE  Before the DB Connection Service sends
an SQL statement after a DB_Update
(Update DB Record) instruction is
executed
 When an SQL statement is stored in the
Spool memory
0003 SELECT Before the DB Connection Service sends an
SQL statement after a DB_Select (Retrieve
DB Record) instruction is executed.
0004 DELETE Before the DB Connection Service sends an
SQL statement after a DB_Delete (Delete DB
Record) instruction is executed.
SQL Execution
Result
0001 INSERT When a response (succeeded/failed) is
returned to the INSERT issued from DB
Connection Service to DB.
0002 UPDATE When a response (succeeded/failed) is
returned to the UPDATE issued from DB
Connection Service to DB.
0003 SELECT When a response (succeeded/failed) is
returned to the SELECT issued from DB
Connection Service to DB.
0004 DELETE When a response (succeeded/failed) is
returned to the DELETE issued from DB
Connection Service to DB.
User-specified
Log
0000 to 9999
(specified by
the user)
DB_PutLog Instruction
Executed
When a DB_PutLog (Record Operation Log)
instruction is executed