RE: How to create logical file with DIGITS statement

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

Of course, that is CREATE VIEW VIEW_NAME (COL1...

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"A true friend is the most precious of all possessions and the one we take
the least thought about acquiring."
        -- La Rochefoucauld 

> Why not do in SQL:
>
> CREATE VIEW (COL1, COL2, COL3, ...) AS
> SELECT COL1, COL2, DIGITS(COL3), ... FROM ...
>
> Dennis Lovelady
> http://www.linkedin.com/in/dennislovelady
> --
> "A true friend is the most precious of all possessions and the one we
> take
> the least thought about acquiring."
>         -- La Rochefoucauld
>
> > In some files I have numeric field1 8 length, 0 decimal,
> > But in other files related field2 is 8 length character with leading
> > zeros.
> > i.e. 608093, 00608093
> > To join it in any report I created a temp file where I have field1
> and
> > field2 created by calling SQL statement:
> > INSERT INTO LIB/TEMP_FILE
> > SELECT FIELD1, DIGITS(FIELD1)
> > FROM PROD_FILE
>
> --
> 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.