× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



The compiler probably uses an internal version of the QDBRTVFD API. You could also use the SYSTABLES (https://www.ibm.com/docs/en/i/7.4?topic=views-systables <https://www.ibm.com/docs/en/i/7.4?topic=views-systables>)

Jon P.


On Jun 23, 2022, at 5:45 PM, Mohammad Tanveer <surgum@xxxxxxxxx> wrote:

Thanks. Just wondering how does OA get name/value pairs of the fields from
a record, I always dreamed of looping through fields and their values in a
generic way without using field names.

Following article is very old but this gave me this crazy thought :)
https://www.ibm.com/developerworks/ibmi/library/i-roaforsql/index.html


On Thu, Jun 23, 2022 at 2:34 PM Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
wrote:

That's not what RPG OA does... RPG OA lets you use traditional RPG
native I/O file operations, but instead of accessing the table, it calls
your code.

So you couldn't use it to create a procedure with parameters like you
suggest.

Instead, I would simply write a procedure like the one you describe.


On 6/23/2022 4:24 PM, Mohammad Tanveer wrote:
I want to call a Procedure with parameters 1. operation(C,R,U,D), 2.
field
names/values and 2.key fields. Based on key fields Procedure will
update/insert/read only those fields in field names/values. Now I can
use
this procedure in my programs to do I/Os. RPG OA allows some kind of
handler program to do similar functions. But I can't find any good
example :)
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.