RE: READP equivalent in SQL.

Alan

Native I/O in C/C++ is also very independent of things - you can work directly with the input and output buffers, e.g., in ways you cannot in RPG. Not sure if this addresses your goals, however.

Later
Vern

-------------- Original message --------------
From: "Alan Campin" <Alan.Campin@xxxxxxxxxxxxxxxx>

am not, by any stretch of the imagination, an SQL
expert.
There may be a way to do what you outlined in SQL, but I must ask, Why?





Why did the chicken cross the road? I guess because it was there.



I am stuck for work and this is kind of a test bed to see how hard or
easy the problem is. I am incorporating it into my trigger utility
programs and this gives me a good way to test theory.



In any case, the same reason always applies to use SQL. Database
independence. If I write a program using file I/O, I am locking that
view of the database into my program. With SQL, I am not and early
indications are using SQL with a user space may actually turn out to be
simpler than using file I/O. Still working on that one. The code will
be available on www.think400.dk/downloads when I get it finished.



In the end, I may decide SQL isn't worth the trouble but no way to find
out except cross the road. I guess the trick is not to get squashed.

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