× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.