Filter
Top Products
App
- 38
Appendix 3 Setting Information File Format (CSV File Format)
Appendix 3.13 ACTION.CSV
APPENDICES
(3) Setting item
(a) For communication action (Select/Update/Insert/MultiSelect/Delete)
(b) For communication action (Stored procedure)
The items other than above will be blank.
(c) For operation action
The items other than above will be blank.
Table App.40 Setting item of communication action (Select/Update/Insert/MultiSelect/Delete)
Item Description Setting value
TYPE Action type
Select [SELECT]
Update [UPDATE]
Insert [INSERT]
MultiSelect [MULTISELECT]
Delete [DELETE]
DB Database 1 to 32
DBTABLE Table name Any character string
— FILEDSNUM DB-Tag link setting 0 to 256
— CONDNUM
Number of select/
update/delete
conditions
When [SELECT], [UPDATE],
[MULTISELECT] or [DELETE] is
selected for TYPE
0 to 8
When [INSERT] is selected for TYPE (Blank)
— EXCEPTNUM
Exception
processing count
When [SELECT], [UPDATE],
[MULTISELECT] or [DELETE] is
selected for TYPE
(DB buffering is disabled)
2
When [INSERT] is selected for TYPE (Blank)
— OPENUM Operation action count (Blank)
— ORDERBYNUM
Sort condition
count
When [SELECT] or [MULTISELECT]
is selected for TYPE
0 to 8
When other than the above is
selected for TYPE
(Blank)
Table App.41 Setting item of communication action (Stored procedure)
Item Description Setting value
TYPE Action type Stored procedure [STOREDPROC]
DB Database 1 to 32
DBTABLE Stored procedure name Any character string
— FILEDSNUM DB-Tag link setting 1 to 257
Table App.42 Setting item of operation action
Item Description Setting value
TYPE Action type Operation [OPERATION]
— OPENUM Operation action count 1 to 20
2
3
4
2
3
4
2