×
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.
Yes I want to go from DDL to DDS. Why would I want to do it?
Last time I asked here, it was stated you can't SQL into arbitrary members
of a PF without assigning them an alias. Ok RPGs gotta be able to talk
directly to a member, every RPG program is a stored procedure, I'll just
learn RPG and write 2 programs. The first will list all members on a file.
the second will take a string of SQL, a file name and a member name, and
then make a temp alias, replace [?] or some other place holder with the
alias name, execute the SQL and drop the member.
According to the tutorial I found variable declaration syntax is DDS. I can
write CREATE TABLE statements in my sleep. It would be really helpful on
this windmill tilting journey if I could create temporary tables in DDL and
spit out DDS to paste into SEU, or better yet a text editor if I can figure
out how to compile RPG from an IFS file or buy an editor that uses the
toolkit.
I'm doing all this on PUB1.DE, which is V5R4. I have access to a 7.1 system
that I have permission to play around with as well if there is something
about this endeavor that screams "IBM Open Access." None of my clients are
V5 or V6 so I don't need that much backwards compatibility. That's just the
box I'm confident my access is restricted enough where I can't cause too
much trouble by accident.
Finally, since I know java, would I have an easier time doing it there and
forgetting this whole RPG exercise? Any caveats to calling RPG APIs from
java?
Justin
As an Amazon Associate we earn from qualifying purchases.
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.