Re: DDS Support

["James W. Kilgore" <eMail@xxxxxxxxxxxxxxxxxxx>]

Mark,

"M. Lazarus" wrote:
> 
<<snip>>
> 
>   Out of curiosity, would you have the same opinion if we were talking
> about replacing CL with REXX?

That would be a bit more of a challenge. <g>  But since REXX is
available on just about every platform and OS, it wouldn't break my
heart to see CL wither on the vine.  Don't get me wrong, I like CL, I'm
just not married to it.

But back to the main topic, I would propose energy should be spent
having SQL enhanced to allow for a REFFLD type of definition and any
other feature that PF/LF DDS possesses that is not within SQL.  In the
mean time, I'll write my own data dictionary and format definition
processor which does have REFFLD capability and use it to generate the
SQL.

> 
> >BTW, if you -do- have to change the underlying DB (and at some time you
> >undoubtedly will), with the appropriate tool you can create new DDS and
> >new SQL and a conversion program when CHGPF or CPYF *MAP *DROP won't do
> >the job for you.
> 
>   When is this the case?
> 
When you take some file that had the date in separate mo/dy/yr fields
and want to create a single field that is a date data type comes to
mind.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---