×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) 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

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.