Re: View to create a PF?

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

How do you refer to a Temp table on the i? this is not accepted:


SELECT *
INTO astccdta.#acbalmpk
FROM
(
 SELECT LMLTPC
  , COALESCE(IRLOC1,'') as IRLOC1
  ,  COALESCE(IRLOC2,'') as IRLOC2
  , COALESCE(IRLOC3,'') as IRLOC3
  , IRPRT#
  , IRQOH#
  , IRWHS#
  , '' as IEPRT#
  , '.00' as IEQOH#
  , '' as IELOC1


On Fri, Aug 23, 2013 at 9:10 AM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

> 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.