Re: Getting DDS for a DDL Generated File (or convince me its unnecessary)

OK, you've already got a lot of responses explaining pretty well that
(1) you don't need RPG at all for what you want to do, and (2) even if
you choose to use RPG anyway, you don't need DDS.

But I feel like mopping up, so:

On Thu, Jan 21, 2016 at 9:45 AM, Justin Dearing <zippy1981@xxxxxxxxx> wrote:

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

You *can* compile RPG from an IFS (stream) file. The CRTBNDRPG command
takes the parameter SRCSTMF, which you can optionally use instead of
SRCFILE and SRCMBR. I don't know when SRCSTMF was introduced; I guess
it's possible that very old systems don't have this.

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?

As you've discovered, there's no need to resort to Java here. Speaking
in general terms, I would say that nowadays you can do almost anything
you care to do using just SQL. A lot of catalogs and functions are
exposed via SQL on recent versions of the i. Check these out:

http://ibm.biz/DB2foriServices
http://www.ibm.com/developerworks/ibmi/techupdates/db2/landscape

(That second one is a PDF "cheat sheet" listing a lot of what's available.)

John Y.