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



Hi Jon

One version of the programs is here
https://wiki.midrange.com/index.php/UDDS_File_Display/Update


I will see if I can find the UNIX API i/o version.

Regards
Frank

On 25/06/2022 12:58 am, Jon Paris wrote:
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


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