My Oracle Support Banner

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.

Purpose

This document provides answers to frequently asked questions on Table I/O Event Rules.

Questions and Answers

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
Purpose
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
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.