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