Re: View to create a PF?

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

I see so that is not bad, I can just create the PF first. The thing is, can
I create the pF with DDS? This seems to be less of a problem for the
reporting tool.


On Fri, Aug 23, 2013 at 8:56 AM, Gary Thompson <gthompson@xxxxxxxxxxx>wrote:

> I guess you want to use the >view which works fine< as the source
> for data in a >new PF< you create ?
>
> I guess you will create your new PF (table) with SQL DDL,
> and then copy data from your >view which works fine< into
> the new PF (table) ?
>
> Steps would seem to be to:
> 1) create the PF with the desired CCSID.
> 2) copy data from view to PF (table)
>
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
> midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hoteltravelfundotcom
> Sent: Friday, August 23, 2013 6:36 AM
> To: Midrange Systems Technical Discussion
> Subject: View to create a PF?
>
> I have a Logical view which works fine but I cannot display the data in
> the Report tool because its CCSID is HEX. If I could create it to PF then I
> could CHGPF on the CCSID (which CHGLF does not have.)
>
> Can this be done?
> This is the code:
>
> CREATE VIEW astlib.acbalmpk AS (
> (SELECT  LMLTPC, COALESCE(IRLOC1,'') as IRLOC1,
> COALESCE(IRLOC2,'')
> as IRLOC2, COALESCE(IRLOC3,'') as IRLOC3, IRPRT#, IRQOH#, IRWHS#,
> '' as IEPRT#,   '.00' as IEQOH#, '' as IELOC1, '' as IELOC2, '' as
> IELOC3, '' as IERIDC, '' as IEWHS#
> FROM
> (SELECT LMLTPC, LMLOC1, LMLOC2, LMLOC3 FROM ASTDTA.ICLOCMLM WHERE LMLTPC
> IN ('PAL', 'RAK' ) )t1 left outer join (SELECT IRLOC1, IRLOC2, IRLOC3,
> IRPRT#, IRQOH#, IRWHS# FROM ASTDTA.ICBLDTIR  ) t2 On LMLOC1=IRLOC1 AND
> LMLOC2=IRLOC2 AND LMLOC3=IRLOC3 ) UNION ALL (SELECT  ' ' as LMLTPC, ' ' as
> IRLOC1, ' ' as IRLOC2, ' ' as IRLOC3, '' as IRPRT#, '.00' as IRQOH#, '' as
> IRWHS#, IEPRT#, IEQOH#, IELOC1, IELOC2, IELOC3, IERIDC, IEWHS# FROM
> ASTDTA.ICBALMIE) )
> --
> 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.