Re: View to create a PF?

how do you code this:
Token ASTCCDTA was not valid. Valid tokens: :.
===> SELECT * INTO astccdta.acbalmpk
FROM ( SELECT LMLTPC , COALESCE(IRLOC1,'')
as IRLOC1 , COALESCE(IRLOC2,'') as IRLOC2 , COALESCE(IRLOC3,''


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

what is the correct Language id ?


Type . . . . . . . . . . . . . : INTEGER
Coded character set ID . . . . . *JOB

*JOB 423
*HEX 424
37 425
256 500
273 833
277 836
278 838
280 870
284 871
285 875
290 880
297 905
420 918


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

yeah that seems to be the way. 65535 is the value.

I am afraid to make any change like that. I already brought down the
system 2x, so I dont' want to 'strike out'. I can't take the chance, I
would have in the past. I understand it's not as bad as I am making it.


On Fri, Aug 23, 2013 at 9:38 AM, <rob@xxxxxxxxx> wrote:

If you just happen to get shit lucky and manage to create the table with
the right CCSID's magically just by creating it with DDS versus DDL then
by all means proceed. After you create the table you can populate it
from
your view with

insert into mytable (select * from myview)


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 08/23/2013 09:11 AM
Subject: Re: View to create a PF?
Sent by: midrange-l-bounces@xxxxxxxxxxxx



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.

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