Re: Flat File to SQL-DDL

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Jerry,

In DDL there are no edit codes. If needed, you can use an UDF. Check Alan
Campin's iDate.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Feb 14, 2011 at 11:49 AM, Jerry C. Adams <midrange@xxxxxxxx> wrote:

> First, I'm on V5R1.
>
> Second, I'm dealing with a legacy application ported years ago to the
> AS/400
> (!) from either a System/34 or /36.
>
> Third, there are no external table definitions except the ones that I have
> created.  I prefer using SQL-DDL, but I have never been about to find an
> equivalent for DDS's EDTCDE and EDTWRD.
>
>
>
> DDL's edit [equivalent to EDTCDE(J)] is find for 90-95% of the cases.
> However, since I'm dealing with legacy files, the dates are 8.0 numeric
> (ccyymmdd), and they get displayed as, for example, 20,110,214 in queries.
> Is there any way to display dates using an edit word, such as ('    -  -
> ')?  Or even something like EDTCDE(Y)?  I use date data types when creating
> new tables, but converting these legacy tables is, for the time being, out
> of the question.
>
>
>
> I RTFM's and could not find anything so I'm surmising that the answer is
> "You're SOL."  But asking is worth a shot.
>
>
>
> Jerry C. Adams
>
> IBM i Programmer/Analyst
>
> --
>
> A&K Wholesale
>
> Murfreesboro, TN
>
> 615-867-5070
>
>
>
> --
> 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.