Re: Can I use DDS to create an SQL table name

On Wed, Oct 22, 2014 at 9:01 AM, <rob@xxxxxxxxx> wrote:

How many utilities really respect EDTCDE and EDTWRD?
Are these 5250 based utilities only?

I agree with you and Luis that this is a relatively minor advantage of DDS.

However, I do have one utility to throw into the (small) pile of those
that do use EDTCDE and EDTWRD, and that's my Python script for copying
data into Excel:

https://bitbucket.org/jky/cpytoxlsf.py

Because our system uses predominantly numeric fields to store dates, I
look for hints, such as EDTWRD(' - - '). (The script does handle
proper date fields as well.) I also support a few edit codes which
determine how the column will be formatted.

I also use COLHDG and TEXT from the DDS. I imagine there are DDL
counterparts to these, but I (currently) don't use them, because we're
almost exclusively a DDS shop.

John Y.