Omron NX701-1620 - Page 302

Index
I-2
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Index
Ａ
Adding a DB Connection ................................................................ 2-8
Assumed cause .............................................................................. 7-8, 7-10
Ｂ
Backup/Restore Function in the DB Connection Service ..................... 5-26
Ｃ
Changing the DB Connection Name ....................................................... 2-8
Checking the Status of each DB Connection ........................................ 4-12
Checking the Status of the DB Connection Service ................................ 4-8
Clearing the Mapping of DB Map Variables .......................................... 3-18
Clearing the SQL Statements from the Spool Memory ......................... 5-10
Column ...................................................................................................... 25
Communications Test ............................................................................ 2-12
Communications Timeout ...................................................................... 5-24
Connected time ..................................................................................... 4-12
Connection name .................................................................................... 2-9
Connection Settings ................................................................................ 2-9
Connection Status ................................................................................. 4-12
Microsoft Excel ...................................................................................... 3-13
Correspondence of Data Types between NJ-series Controllers and DB 3-4
Creating a Structure Data Type ............................................................... 3-3
Ｄ
Data Already Spooled ............................................................................ 7-37
Database type ......................................................................................... 2-9
DB ........................................................................................................ 25
DB Connection .......................................................................................... 25
DB Connection Already Established ..................................................... 7-27
DB Connection Disconnected Error ...................................................... 7-20
DB Connection Disconnected Error Status ........................................... 7-35
DB Connection Failed ............................................................................ 7-26
DB Connection function ............................................................................. 25
DB Connection Instruction ......................................................................... 25
DB Connection Instruction Execution Timeout ..................................... 7-36
DB Connection Instruction Set .............................................................. 3-24
DB Connection Rejected ....................................................................... 7-26
DB Connection Service ..................................................................... 25, 1-5
DB Connection Service Error Stop ........................................................ 7-36
DB Connection Service Initializing ........................................................ 7-37
DB Connection Service Not Started ...................................................... 7-23
DB Connection Service Run Mode Change Failed ............................... 7-24
DB Connection Service Settings ............................................................. 2-5
DB Connection Service Shutdown ........................................................ 7-22
DB Connection Service shutdown function .............................. 25, 1-5, 5-15
DB Connection Service Shutdown or Shutting Down ........................... 7-25
DB Connection Service Started ............................................................. 7-21
DB Connection Service Status .............................................................. 3-25
DB Connection Service Stopped ........................................................... 7-21
DB Connection Setting Error ................................................................. 7-19
DB Connection settings ........................................................................... 2-5
DB Connection Settings .......................................................................... 2-8
DB Connection System ........................................................................... 1-7
DB in Process ........................................................................................ 7-38
DB Map Variable ....................................................................................... 25
DB Map Variables and DB Mapping ..................................................... 3-15
DB mapping ....................................................................................... 25, 3-2
DB_Close ............................................................................................... 3-24
DB_Close (Close DB Connection) .......................................................... A-9
DB_Connect .......................................................................................... 3-24
DB_Connect (Establish DB Connection) .............
.................................... A-6
DB_ControlService ................................................................................ 3-24
DB_ControlService (Control DB Connection Service) .......................... A-54
DB_ControlService (Control DB Connection Service) instruction ........... 4-4
DB_ControlSpool ................................................................................... 3-24
DB_ControlSpool (Resend/Clear Spool Data) ...................................... A-71
DB_ControlSpool (Resend/Clear Spool Data) instruction .............. 5-9, 5-10
DB_CreateMapping ........................................................ 3-2, 3-18, 3-24
DB_CreateMapping (Create DB Map) ................................................... A-11
DB_CreateMapping (Create DB Map) instruction ................................. 3-15
Registration and Attributes of DB Map Variables .................................. 3-16
DB_Delete.............................................................................................. 3-24
DB_Delete (Delete DB Record) ............................................................. A-39
DB_GetConnectionStatus ..................................................................... 3-24
DB_GetConnectionStatus (Get DB Connection Status) ....................... A-65
DB_GetConnectionStatus (Get DB Connection Status) instruction ...... 4-14
DB_GetServiceStatus ............................................................................ 3-24
DB_GetServiceStatus (Get DB Connection Service Status) ................ A-60
DB_Insert .................................................................................... 3-2, 3-24
DB_Insert (Insert DB Record) ................................................................ A-14
DB_Insert (Insert DB Record) instruction ................................................ 5-4
DB_PutLog ............................................................................................ 3-24
DB_PutLog (Record Operation Log) ..................................................... A-78
DB_Select ................................................................................... 3-2, 3-24
DB_Select (Retrieve DB Record) .......................................................... A-34
DB_Shutdown ........................................................................................ 3-24
DB_Shutdown (Shutdown DB Connection Service) ............................. A-84
DB_Update ................................................................................. 3-2, 3-24
DB_Update (Update DB Record) .......................................................... A-18
DB_Update (Update DB Record) instruction ........................................... 5-4
Debug Log ................................................................................................ 25
Dedicated area for the Spool function ..................................................... 5-6
Disconnected time ................................................................................. 4-12
Disconnection date/time ........................................................................ 4-12
Displaying DB Connection Instructions on Sysmac Studio ................... 3-23
Ｅ
EM Area ................................................................................................... 5-7
Error code .............................................................................................. 4-13
Error message ....................................................................................... 4-13
Errors ............................................................................................... 7-5, 7-6
Establishing/Closing a DB Connection .................................................... 4-6
Event code ...................................................................................... 7-8, 7-10
Event name ..................................................................................... 7-8, 7-10
Execution Log .................................................................................... 25, 2-6
Execution Log Save Failed .................................................................... 7-17
Ｈ
How to Create a Structure Data Type for DB Access ........................... 3-12
How to Prevent Losing SQL Statements at Power Interruption ............ 5-18
Ｉ
INSERT operation .................................................................................... 1-4
Instruction Execution Timeout ............................................................... 5-24