RE: Storing source as DDL instead of DDS

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/