Omron NX701-1620 User Manual

Appendix A
A-35
A
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
DB_Select (Retrieve DB Record)
In-out Variables
Name
Meaning
Data type
Valid range
Unit
Description
MapVar DB Map
Variable
Structure,
Structure
array (entire
array)
Depends on
the data type.
--- Specify the DB Map Variable mapped by a
DB_CreateMapping instruction.
Output Variables
Name
Meaning
Data type
Valid range
Unit
Description
Done Done BOOL TRUE or
FALSE
--- TRUE when the instruction is normally
completed.
Busy Executing BOOL TRUE or
FALSE
--- TRUE when the instruction is being executed.
Error Error BOOL TRUE or
FALSE
--- TRUE when the instruction is terminated due to
an error.
ErrorID Error Code WORD 16#0000 to
16#FFFF
--- Contains the error code when an error occurs.
RecCnt Number of
Records
DINT 0 to 65535 --- Contains the number of records that were
retrieved to the DB Map Variable.
SelectedCnt Number of
Retrieved
Records
DINT 0 to
2147483647
--- Total number of records retrieved according to
the retrieval conditions.
Related System-defined Variables
Name
Meaning
Data type
Description
_EIP_EtnOnlineSta Online BOOL Status of the communications function of
the built-in EtherNet/IP port.
TRUE: Can be used.
FALSE: Cannot be used.
Related Error Codes
Error code
Meaning
Description
0400 hex
Input Value Out of Range
The value of the TimeOut input variable is outside the valid range.
041D hex Too Many Instructions Executed at the
Same Time
More than 32 DB Connection Instructions were executed at the same
time.
3000 hex DB Connection Service not Started The instruction was executed when the DB Connection Service was not
running.
3002 hex DB Connection Service Shutdown or
Shutting Down
The instruction was executed after the DB Connection Service was shut
down or while the DB Connection Service was being shut down.
3008 hex Invalid DB Connection The value of the DBConnection input variable is invalid or the specified
DB Connection is already closed.
300A hex DB Map Variable Unregistered The variable specified in the MapVar in-out variable has not been mapped
by a DB_CreateMapping instruction.
300B hex SQL Execution Error The executed SQL statement resulted in an error in the DB.
The retrieved record contains a column whose value is NULL.
The combination of data types is not listed in the table of data type
correspondence between NJ/NX-series Controllers and database and the
data type cannot be converted.
300E hex Invalid Retrieval Conditions The Where input variable is a text string consisting of NULL characters
(16#00) only.
DB Connection Instructions

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English