Table I/O - Using Handles vs. Fetch Single

What are the advantages/disadvantages of using a handle vs. a regular fetch single for table I/O? When I took a JDE report writing class at Oracle, the instructor said to always use handles if they are available. But since then, some JDE programmers have said they NEVER use handles. What is the best practice?
thanks!

Hi elbyowl,

First check the Development Tools manual about Table I/O Handles and you will find answers for your question. No need to re-type the manual here

Regards,

Zoltán

Handles are very powerful and are used when you want the ability to fetch
data from a different data source. For example fetching data from PD810
while the report is running in DV7333. Most of the developers do not use
them unless it is very much essential. Lot of clients would not encourage
the use of it as there is a big chance of data integrity being compromised
if used incorrectly.

SMSS




--
Thanks,
Madhu

Probably the biggest reason to use handles is when you need to have multiple instances of the table open at the same time, each returning a different multi-record result.

In ER code this is the only time I have used table handles.