E1: FDA: RDA: Frequently Asked Questions on Table I/O Event Rules
(Doc ID 1393085.1)
Last updated on JANUARY 27, 2020
Applies to:JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.
This document provides answers to frequently asked questions on Table I/O Event Rules.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Questions and Answers|
|Question 1: Where can I find Additional Information on Table I/O Event Rules?|
|Question 2: When Should Handles be used with Table I/O?|
|Question 3: How do I use a Handle in Table I/O?|
|Question 4: How can I select multiple records from a Table using Table I/O?|
|Question 5: Why do I receive an error of "JDB3300020 - Fetch not allowed. Prior successful Select operation required for this request" in the log ?|
|Question 6: Why does a NER with Table I/O consisting of Multiple Select and Fetch Next Statements result in an Invalid Handle Error?|
|Question 7: Why does the Table I/O Operation always returns 'CO SUCCESS' when performing and Update or Delete Operation?|
|Question 8: Can Table I/O be used to access data from another environment?|
|Question 9: Can Table I/O be performed on a Parent/Child Browse Form?|
|Question 10: How can I use Buffered Inserts with Table I/O?|
|Question 11: Why is the index specified in a Table I/O operation, not used when the actual SQL statement is run?|
|Question 12: Why do I receive an error of "JDB3300020 - Fetch not allowed. Prior successful Select operation required for this request" in the log ?|
|Question 13: Is there any BETWEEN operator available in table I/O operation?|
|Question 14: How to code LIKE Operation in Table I/O Event Rule ?|
|Question 15: Can Table IO (TIO) Handle created by Interactive Application be passed in to C/NER business function running on server to continue fetching data ?|
|Question 16: Table IO Insert/Update allows value greater than the maximum value based on data dictionary item size to be inserted/updated in Numeric column SQL/Oracle DB but not in DB2/400|