My Oracle Support Banner

E1: FDA: RDA: Frequently Asked Questions on Table I/O Event Rules (Doc ID 1393085.1)

Last updated on NOVEMBER 06, 2023

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
 Question 17: Is it normal to have the same fields from the selected index for both SET and WHERE clause in the UPDATE SQL statement generated for table IO Update operation?
References

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