Re: View to create a PF?

also it needs to be a dynamic copy of the view records to the pf.


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

Luis, but that won't be a dds based file.Actaully I was thinking to make
PF first and then load in the records but I will try this idea.


On Fri, Aug 23, 2013 at 10:39 AM, <rob@xxxxxxxxx> wrote:

Well, it may depend on your location. As a lily white American of
European descent 37 works fine for me.


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 10:02 AM
Subject: Re: View to create a PF?
Sent by: midrange-l-bounces@xxxxxxxxxxxx



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.

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