Omron SYSMAC NX series, User Manual

Page: 12 / 20

5-2-2 Spooling System .........................................................................................................................5-5
5-2-3 Applicable Instructions and Spooling Execution Conditions .......................................................5-5
5-2-4 Memory Area Used by the Spool Function .................................................................................5-6
5-2-5 Spool Function Settings ..............................................................................................................5-8
5-2-6 How to Resend the SQL Statements Stored in the Spool Memory.............................................5-9
5-2-7 Clearing the SQL Statements from the Spool Memory .............................................................5-10
5-2-8 Relationship with the DB Connection Instructions ....................................................................5-12
5-2-9 How to Estimate the Number of SQL Statements that can be Spooled....................................5-14
5-3 Stored Procedure Call Function .........................................................................................5-16
5-3-1 Overview ...................................................................................................................................5-16
5-3-2 Specifications of the Stored Procedure Call Function for Databases .......................................5-17
5-3-3 How to Execute the Stored Procedure Call Function................................................................5-19
5-3-4 Specifying the Table and Applying the Mapping .......................................................................5-20
5-3-5 Errors during Stored Procedure Call .........................................................................................5-22
5-4 Batch Insert Function ..........................................................................................................5-24
5-4-1 Overview ...................................................................................................................................5-24
5-4-2 How to Execute the Batch Insert Function ................................................................................5-25
5-5 DB Connection Service Shutdown Function.....................................................................5-26
5-5-1 Overview ...................................................................................................................................5-26
5-5-2 Shutdown System .....................................................................................................................5-26
5-5-3 How to Execute the Shutdown Function ...................................................................................5-27
5-5-4 How to Check the Shutdown of the DB Connection Service.....................................................5-27
5-6 How to Prevent Losing SQL Statements at Power Interruption ......................................5-28
5-6-1 Overview ...................................................................................................................................5-28
5-6-2 Procedures................................................................................................................................5-28
5-7 Timeout Monitoring Functions ...........................................................................................5-33
5-7-1 Timeout Monitoring Functions ...................................................................................................5-33
5-7-2 Login Timeout............................................................................................................................5-33
5-7-3 Query Execution Timeout..........................................................................................................5-34
5-7-4 Communications Timeout..........................................................................................................5-34
5-7-5 Instruction Execution Timeout ...................................................................................................5-35
5-7-6 Keep Alive Monitoring Time ......................................................................................................5-35
5-8 Other Functions ...................................................................................................................5-36
5-8-1 Backup/Restore Function in the DB Connection Service..........................................................5-36
5-8-2 Operation Authority Verification in the DB Connection Service.................................................5-37
5-8-3 Encrypted Communication ........................................................................................................5-38
Section 6 How to Use Operation Logs
6-1 Operation Logs ......................................................................................................................6-2
6-2 Execution Log ........................................................................................................................6-3
6-2-1 Overview .....................................................................................................................................6-3
6-2-2 Application Procedure .................................................................................................................6-3
6-2-3 Setting the Execution Log ...........................................................................................................6-3
6-2-4 Checking the Execution Log .......................................................................................................6-4
6-2-5 Execution Log File Specifications ...............................................................................................6-4
6-3 Debug Log ............................................................................................................................6-15
6-3-1 Overview ...................................................................................................................................6-15
6-3-2 Application Procedure ...............................................................................................................6-15
6-3-3 Set the Debug Log ....................................................................................................................6-15
6-3-4 Start Recording to the Debug Log.............................................................................................6-16
6-3-5 Stopping Recording to Debug Log ............................................................................................6-17
6-3-6 Checking the Debug Log...........................................................................................................6-18
6-3-7 Debug Log File Specifications...................................................................................................6-18
6-4 SQL Execution Failure Log .................................................................................................6-29
6-4-1 Overview ...................................................................................................................................6-29
6-4-2 Application Procedure ...............................................................................................................6-29
6-4-3 Setting the SQL Execution Failure Log .....................................................................................6-29
CONTENTS
10
NJ/NX-series Database Connection CPU Units User’s Manual (W527)