×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
iNav has about option to "Generate SQL", which will give you the DDL source for a PF. You can display it, or save it (PC file or source member). I've never had good luck saving to a source member. When I had to do it, I just displayed the generated source and did a copy-and-paste into a source member in RDi.
This can also be used for DDS PF's, although some keywords aren't supported. I don't know of any way to automatically preserve the data when going that route.
I don't typically save the DDL source. I guess it would help if you wanted to store it in your SCM solution.
-----Original Message-----
From: Steinmetz, Paul [mailto:PSteinmetz@xxxxxxxxxx]
Sent: Friday, February 24, 2017 10:41 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxx>
Subject: Storing source as DDL instead of DDS
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/
midrange.com
