I don't see in your description of what you want to do anywhere where
DDS would be needed?
Filea with members B and C.
Sql that wants to insert into C.
RPG program gets SQL, File A, member C. Create alias tempxyz on A(c).
Run sql on tempxyx. Drop alias tempxyz.
Is that the workflow?
Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Justin Dearing
Sent: Thursday, January 21, 2016 8:45 AM
To: Midrange Systems Technical Discussion
Subject: Getting DDS for a DDL Generated File (or convince me its
unnecessary)
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 is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
midrange.com
