× 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.



Yes, you have to convert the source. But Aldon includes a utility that
invokes the Generate Data Definition Language (QSQGNDDL) API.

I usually have a reason for converting from DDS to DDL. So the 15 seconds
it takes isn't a waste.

Charles

On Wed, Oct 22, 2014 at 10:20 AM, John R. Smith, Jr. <smith5646@xxxxxxxxx>
wrote:

I'm confused.

"I would expect CM system to be able to handle this. I know Aldon does. I
check out a DDS PF object, change it DDL *TABLE and promote it back."

Don't you have to convert the DDS to DDL to do this (or am I confused on
what DDL is)? That would be the waste of time.


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Charles Wilt
Sent: Wednesday, October 22, 2014 10:02 AM
To: Midrange Systems Technical Discussion
Subject: Re: Can I use DDS to create an SQL table name

Just wanted to address a couple of points

On Wed, Oct 22, 2014 at 7:10 AM, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:

Besides that there are tons of DDS out there and converting these to
DDL is not only a waste of time but may also interfere with existing
Change Management systems.


​I would expect CM system to be able to handle this. I know Aldon does. I
check out a DDS PF object, change it DDL *TABLE​ and promote it back. No
issues. Just like I can check out a OPM RPG III object and convert it to
an ILE RPG IV *MODULE or *PGM object.




I have looked into making a Data Definition/Change Management system
based on DDL and that is far more complicated than initial meets the
eye because the structure of SQL where columns and its properties
can't be defined in a single statement and SQL doesn't have the
automatization level that DDS/CHGPF (that implement all changes to a DB
object in one command) has.


​Again, a smart enough CM can handle this. Aldon checks to see rather or
not it can use CHGPF or ALTER TABLE before resorting to recreating the file
or table.​
--
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.


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



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.