Some have been posted to this list in the past. The stuff I have mostly relates to display file I/O not database.


Jon P.

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

Any C examples?

The idea is to call the procedure wherever we do add/update/delete using
RPG operation or SQL on a table so that all CRUD operations are in one
service program procedure which can even be called from Stored Proc. I can
write a custom program for all that but I thought RPG OA can help?

On Thu, Jun 23, 2022 at 2:28 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

OA will not really help you here. Generating and executing dynamic SQL
statements would be a better fit. If you look at the OA articles I
referenced you'll understand what I mean.

The other option for building generic I/O routines is to use the C library
IBM i specific I/O functions.


Jon P.

On Jun 23, 2022, at 5:24 PM, Mohammad Tanveer <surgum@xxxxxxxxx> 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 :)

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

wrote:

You don't need RPG Open Access to perform CRUD operations on a table.
That's already what CRUD operations do, they access a table.

Can you explain better?



On 6/23/2022 4:03 PM, Mohammad Tanveer wrote:
I have been reading about RPG Open Access and wondering if there is a
good
sample or example?

I am trying to create a procedure to do CRUD operations on a Table. I
feel
like RPG OA framework can be used to do it. But need some good
examples
:)
--
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

--
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 ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2022 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.