Checking the SQL Execution Failure Log .................................................................................6-30
SQL Execution Failure Log File Specifications .........................................................................6-30
6-5 SD Memory Card Operations ..............................................................................................6-36
Saving Operation Log Files on SD Memory Card .....................................................................6-36
Directory Used for DB Connection Service ...............................................................................6-36
Operation Log Operations in Replacing the SD Memory Card .................................................6-37
Guidelines for SD Memory Card Replacement Time ................................................................6-37
Replacement Timing of SD Memory Card.................................................................................6-38
6-6 Checking the Operation Logs.............................................................................................6-39
How to Check the Operation Logs ............................................................................................6-39
Checking the Log on the Operation Log Window in Sysmac Studio.........................................6-39
Checking the Log with the SD Memory Card ............................................................................6-41
Checking the Log by Transfer using FTP Client Software ........................................................6-41
DB Connection Instructions and Variables ...................................................................................7-2
DB Connection Instruction Set......................................................................................................................7-2
Variables Used in the DB Connection Instructions .......................................................................................7-2
DB_Connect (Establish DB Connection) .......................................................................................7-6
Variables .......................................................................................................................................................7-6
Related System-defined Variables................................................................................................................7-7
Related Error Codes .....................................................................................................................................7-7
Function ........................................................................................................................................................7-7
Precautions for Correct Use .........................................................................................................................7-8
Sample Programming ...................................................................................................................................7-9
DB_Close (Close DB Connection) ................................................................................................7-10
Variables .....................................................................................................................................................7-10
Related System-defined Variables..............................................................................................................7-11
Related Error Codes ...................................................................................................................................7-11
Function ......................................................................................................................................................7-11
Precautions for Correct Use .......................................................................................................................7-11
Sample Programming .................................................................................................................................7-12
DB_CreateMapping (Create DB Map) ...........................................................................................7-13
Variables .....................................................................................................................................................7-13
Related System-defined Variables..............................................................................................................7-14
Related Error Codes ...................................................................................................................................7-14
Function ......................................................................................................................................................7-15
Precautions for Correct Use .......................................................................................................................7-15
Sample Programming .................................................................................................................................7-16
DB_Insert (Insert DB Record) .......................................................................................................7-17
Variables .....................................................................................................................................................7-17
Related System-defined Variables..............................................................................................................7-18
Related Error Codes ...................................................................................................................................7-18
Function ......................................................................................................................................................7-19
Precautions for Correct Use .......................................................................................................................7-19
Sample Programming .................................................................................................................................7-20
Variables .....................................................................................................................................................7-21
Related System-defined Variables..............................................................................................................7-22
Related Error Codes ...................................................................................................................................7-22
Function ......................................................................................................................................................7-23
Precautions for Correct Use .......................................................................................................................7-24
Sample Programming .................................................................................................................................7-25
DB_Select (Retrieve DB Record) ..................................................................................................7-39
Variables .....................................................................................................................................................7-39
Related System-defined Variables..............................................................................................................7-40
Related Error Codes ...................................................................................................................................7-40
Function ......................................................................................................................................................7-41
CONTENTS
11
NJ/NX-series Database Connection CPU Units User’s Manual (W527)