Field list
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
||
|---|---|---|---|---|---|---|
|
ID |
|
Alphanumeric characters and symbols (#1) |
No |
50 bytes or fewer |
||
|
Business group |
|
A business group for which general users have access permissions. Alternatively, a business group whose only purpose is to be used for filter conditions. |
Yes |
|
||
|
Comment |
|
Characters (#3) |
Yes |
255 bytes or fewer |
||
|
I/O category |
The value is specified in the dialog box. |
Input or Output |
No |
|
||
|
Database connection ID |
|
Alphanumeric characters and symbols (#1) |
No |
50 bytes or fewer |
||
|
Specification method |
Simple |
Simple, SQL statement |
No |
|
||
|
Specification method = Simple |
||||||
|
|
Table name |
|
Characters (#2) |
No |
255 bytes or fewer |
|
|
No. |
|
A serial number starting from 1. Display only |
|
|
||
|
Field name |
|
Display only |
|
|
||
|
Fixed/Variable length |
|
Display only |
|
|
||
|
Size |
|
Display only |
|
|
||
|
Field type |
|
Display only |
|
|
||
|
Status |
|
Display only |
|
|
||
|
Comment |
|
Display only |
|
|
||
|
I/O category = Input |
||||||
|
|
Sort order |
Do not sort |
Do not sort, Ascending, Descending |
No |
|
|
|
Field name |
|
Alphanumeric character |
Yes |
If I/O category is Input: 255 bytes or fewer |
||
|
Comments |
|
Characters (#3) |
Yes |
255 bytes or fewer |
||
|
I/O category = Output |
||||||
|
|
Update method |
INSERT |
INSERT, INSERT by using direct path loading function (if the connection-target database is Oracle), BULK INSERT (in the case of ODBC, only supported for Redshift or Snowflake), UPDATE rows that match the key value |
No |
|
|
|
Specification method = SQL statement |
||||||
|
|
I/O category = Input |
|||||
|
|
SQL statement |
|
SQL statement (#4) |
No |
99,999 bytes or fewer |
|
|
I/O category = Output |
||||||
|
|
Update method |
Execute only SQL 1 |
Execute both SQL 1 and SQL 2Execute SQL 2 only if SQL 1 fails |
No |
|
|
|
SQL statement of SQL1 |
|
SQL statement (#4) |
No |
99,999 bytes or fewer |
||
|
SQL statement of SQL2 |
|
SQL statement (#4) |
No |
99,999 bytes or fewer |
||
|
Common specifications |
||||||
|
|
SQL statement before beginning |
|
SQL statement (#4) |
Yes |
99,999 bytes or fewer |
|
|
SQL statement after ending normally |
|
SQL statement (#4) |
Yes |
99,999 bytes or fewer |
||
|
#1 |
: |
You can use only hyphen (-), underscore (_), period (.), left parenthesis ((), and right parenthesis ()). |
|
#2 |
: |
You cannot use external characters. Operations are not guaranteed if you use any platform-dependent characters. |
|
#3 |
: |
No line breaks can be registered. |
|
#4 |
: |
You can now include the dynamic value "$DNUMXX" and the dynamic character string "$DSTRXX" ("XX" is a value in the range of 01 to 20). |
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
|---|---|---|---|---|
|
No. |
|
Display only |
|
|
|
Field name |
|
Characters (#1) |
No |
255 bytes or fewer |
|
Fixed/Variable length |
Fixed length |
Fixed length, Variable length |
No |
|
|
Maximum size |
|
1 to 9999999999, 0 (Unrestricted) |
No |
If Fixed/Variable length is Variable length |
|
Size |
|
0 to 9999999999 |
No |
If I/O Category is Input and Fixed/Variable length is Fixed length |
|
|
1 to 9999999999 |
No |
If I/O Category is Output and Fixed/Variable length is Fixed length |
|
|
Field type |
B |
B: binary F: floating point I: image, no conversion M: variable-length characters N: double-byte graphic characters D: date Z: numeric character string W: Unicode character string |
No |
|
|
Concatenation sequence |
1 |
1 to 1000 |
No |
If the method is SQL statement specification |
|
Status |
Enabled |
Enabled, Disabled |
No |
|
|
Key |
Empty |
* or empty |
No |
|
|
Comment |
|
Characters (#2) |
Yes |
255 bytes or fewer |
|
#1 |
: |
You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), ampersands (&), commas (,), or external characters. Operations are not guaranteed if you use any platform-dependent characters. |
|
#2 |
: |
No line breaks can be registered. |
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
|---|---|---|---|---|
|
Table name |
|
Display only |
|
|
|
Field Name |
Initial value |
Possible settings |
Omission possible |
Remarks |
|---|---|---|---|---|
|
Table search |
|
Characters (#1) |
No |
255 bytes or fewer |
|
Search method |
The above ID and all subsequent IDs (in ASCII order) |
All IDs that begin with the above ID, The above ID and all subsequent IDs (in ASCII order) , Equals |
No |
|
|
#1 |
: |
You cannot use external characters. Operations are not guaranteed if you use any platform-dependent characters. |
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
|---|---|---|---|---|
|
No. |
|
Display only |
|
|
|
Field name |
|
Display only |
|
|
|
Fixed/variable length |
|
Display only |
|
|
|
Size |
|
Display only |
|
|
|
Field type |
|
Display only |
|
|
|
Key |
|
Display only |
|
|