Omron NX701-1620 User Manual

3 Programming the DB Connection Function
3-4
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Precautions for Correct Use
Restrictions on Table’s Column Names:
You need to specify the same name for structure members to be used in NJ/NX-series
Controllers as the column names of the table to access.
There are following restrictions on structure member names in the NJ/NX-series
Controllers. Therefore, make the column names satisfy the following conditions.
Item
Description
Usable characters 0 to 9, A to Z, a to z
Single-byte Japanese kana
_ (underscores)
Multi-byte characters (e.g., Japanese)
Characters that
cannot be used
together
- A text string that starts with a number (0 to 9)
- A text string that starts with P_
- A text string that starts with an underscore (_) character
- A text string that contains more than one underscore (_) character
- A text string that ends in an underscore (_) character
- Any text string that consists of an identifier and has a prefix or postfix which contains
more than one extended empty space character (i.e., multi-byte spaces or any other
empty Unicode space characters)
 Correspondence of Data Types between NJ/NX-series Controllers and DB
The correspondence of data types between NJ/NX-series Controllers and DB is given in the
following tables.
 Oracle
Data type category
Data type in DB
Data type in NJ/NX-series Controllers
Characters
VARCHAR2
STRING
*1
NVARCHAR2
STRING
*1
CHAR
STRING
*1
NCHAR
STRING
*1
LONG
None
CLOB
None
NCLOB
None
Numbers
*2
NUMBER(1)
NUMBER(3)
NUMBER(5)
NUMBER(10)
NUMBER(19)
NUMBER(3)
NUMBER(5)
NUMBER(10)
NUMBER(20)
*3
BOOL
SINT
INT
DINT
LINT
USINT
UINT
UDINT
ULINT
NUMBER(19)
TIME
*4
BINARY_FLOAT
REAL
BINARY_DOUBLE
LREAL
FLOAT
REAL
INTEGER
DINT
Date
DATE
DATE
TIMESTAMP DATE
DATE_AND_TIME
TIMESTAMP WITH TIMEZONE
DATE_AND_TIME
TIMESTAMP WITH LOCAL TIMEZONE
DATE_AND_TIME
INTERVAL YEAR TO MONTH
None

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English