To Next Page

To Previous Page

5-1

NJ/NX-series Database Connection CPU Units User’s Manual (W527)

This section describes other functions of the DB Connection Service.

5-1 Examples of Using Functions ....................................................................... 5-2

5-2 Spool Function .............................................................................................. 5-4

5-2-1 Overview ...........................................................................................5-4

5-2-2 Spooling System ...............................................................................5-4

5-2-3 Applicable Instructions and Spooling Execution Conditions ............5-4

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 DB Connection Service Shutdown Function ............................................... 5-15

5-3-1 Overview ........................................................................................ 5-15

5-3-2 Shutdown System .......................................................................... 5-16

5-3-3 How to Execute the Shutdown Function ....................................... 5-16

5-3-4 How to Check the Shutdown of the DB Connection Service ......... 5-17

5-4 How to Prevent Losing SQL Statements at Power Interruption .................. 5-18

5-4-1 Overview ........................................................................................ 5-18

5-4-2 Procedures .................................................................................... 5-18

5-5 Timeout Monitoring Functions ..................................................................... 5-22

5-5-1 Timeout Monitoring Functions ....................................................... 5-22

5-5-2 Login Timeout ................................................................................ 5-23

5-5-3 Query Execution Timeout .............................................................. 5-23

5-5-4 Communications Timeout .............................................................. 5-24

5-5-5 Instruction Execution Timeout ....................................................... 5-24

5-5-6 Keep Alive Monitoring Time........................................................... 5-24

5-6 Other Functions .......................................................................................... 5-26

5-6-1 Backup/Restore Function in the DB Connection Service .............. 5-26

5-6-2 Operation Authority Verification in the DB Connection Service .... 5-28

Other Functions

Omron NX701-1620 User Manual

Questions and Answers: