I was at the same meeting as Paul was yesterday and I think the question is really both. Who is using DDL to define tables (files) and moved away from DDS. And if you have done that, how, benefits, tools to assist. And if you have do you store the DDL source at all and if so where. Since it is possible to retrieve the DDL from the existing table object (file) using iNavigator tools do you need to keep the source at all? Do you even create source first and then "compile" the file from the source or just create the table using the iNav GUI and let it self document.
Paul, This is a good overview of concept
http://www.ibmsystemsmag.com/ibmi/developer/modernization/dbmodernization_part3/
Mike Cunningham
VP of Information Technology Services/CIO
Pennsylvania College of Technology
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Friday, February 24, 2017 2:40 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Storing source as DDL instead of DDS
Paul
Is everyone missing the point of your question? Or are you asking something different?
The subject is about storing source, NOT converting from DDS to DDL - is that right?
It is possible to use source in the IFS for ILE compile commands. I really do not think this is what this is about. Source stored in the IFS is in stream files - tables created with DDL are not treated like stream files, so far as I know.
So I'm very confused by the question AND by the responses, that seem to have missed the target completely.
Elucidate, please!!!
Vern
On 2/24/2017 10:41 AM, Steinmetz, Paul wrote:
I was at a new Pennsylvania IBM users group yesterday.
Name TBD, looking for new members.
It was mentioned about storing source as DDL instead of DDS.
Anyone doing this?
How is done?
Pros/cons?
Is there a migration utitlity?
Thank You
_____
Paul Steinmetz
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home
psteinmetz@xxxxxxxxxx
http://www.pencor.com/
--
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.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
________________________________
This email may contain confidential information about a Pennsylvania College of Technology student. It is intended solely for the use of the recipient. This email may contain information that is considered an “educational record” subject to the protections of the Family Educational Rights and Privacy Act Regulations. The regulations may be found at 34 C.F.R. Part 99 for your reference. The recipient may only use or disclose the information in accordance with the requirements of the Federal Educational Rights and Privacy Act Regulations. If you have received this transmission in error, please notify the sender immediately and permanently delete the email.
midrange.com
