Re: Generic RPG File Handler for File I/O (was using OA)

I'd certainly like to see the code Frank if you can locate it.

I get requests for this kind of example quite regularly.


Jon P.

On Jun 23, 2022, at 8:00 PM, Frank Kolmann <Frank.Kolmann@xxxxxxxxx> wrote:

I have no clue what OA is, and am not asking.
Way back when before AS400 existed in S38 days I wrote a generic file display/updater in RPGIII using UDDS and DSPFFD.
Dont think I still have the RPGIII code.
It could display/update/delete/add records but did not have file creation.

I progressively updated it and the last version was in free form RPG using the UNIX file APIs to do the file IO and DSM apis.

It worked well, except I could not figure out how to handle Null Capable fields. I got stuck on that.
I could not get the Null Indicator maps to populate properly.
Problem was the Null Indicator maps are specific to the file and I was unable to generalise the maps.
Also there is some sort of compiler restriction on getting generic Null field handling to work.
Still got the code somewhere if anyone is interested.
When SQL finally was fixed I no longer needed the utility, but it did have a nice way to see all related lgl files.

Frank


On 24/06/2022 9:25 am, Jon Paris wrote:

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

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