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


  1.  Home
  2. MIDRANGE-L
  3. September 2018

RE: Viewing packed decimal field as a string

Rob, Exactly.

The reason this whole request came up is that a string field that is critical to our business was easily searchable globally in the journals, but we are planning on switching it an integer or packed decimal field and both exhibit these problems of viewability in the journal.

Matt

-----Original Message-----
From: Rob Berendt <rob@xxxxxxxxx>
Sent: Wednesday, September 12, 2018 6:25 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Viewing packed decimal field as a string

Ok ideas, but think back to the OP's request. He'd have to:
Find the file in the current journal receiver entry.
Retrieve the field descriptions.
Check every column for that value.

He just wants to see if the whole row has the string, in any position, irregardless of the position. Kind of like searching for a string in DSPPFM, but against multiple files.


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: "Gary Monnier" <gmonnier@xxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 09/11/2018 05:51 PM
Subject: Re: Viewing packed decimal field as a string
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



I was thinking more of you using the COLUMNS view or the Retrieve
Database
File Description (QDBRTVFD) API to obtain column info such as starting
position, data type, length, number of decimal positions.




Gary Monnier
*ATI Administrator*
*425.427.7959*

On Tue, Sep 11, 2018 at 2:01 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

Why? Are you suggesting copying the journal entries to a database would
solve the data incompatibilities? And then would allow the LIKE (or
some
similar function in RPG) to work?

Here, our journal usage is measured in TB. So copying to temp work
files
is not something I like to do on a whim.


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
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.
dekko.com&d=DwICAg&c=pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_
ztz5b0wbCtdhwrG0PzYq8&m=5fzPK9rqCiyVfBL6_bYTAJv34oAJd2ynzjZVzr7-DKA&s=
CwnZVrTbuXJ3I1WF_bsco7_GmWkRXTGYMPO_g4nkCpo&e=





From: "Gary Monnier" <gmonnier@xxxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxx>
Date: 09/11/2018 04:23 PM
Subject: Re: Viewing packed decimal field as a string
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Does the process of looking at the journal have to be in SQL?


Gary Monnier
*ATI Administrator*
*425.427.7959*

On Tue, Sep 11, 2018 at 1:17 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

Nice plug but really won't solve the problem.

If the packed number is stored as COL01 in TABLE01, COL02 in TABLE22,
COLX
in TABLE and ... to the point where he has no idea whatever other
column
names, in whatever other tables.
The one thing these tables have in common is that they are all
journaled
to the same journal. Their offset is different based on where the
column
is in the row,etc. Heck one column may be 7 packed, one may be 9
packed.
He just wants to find all updates to any table that had a packed 12345
updated or inserted between two times.


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
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.
dekko.com&d=DwICAg&c=pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_
ztz5b0wbCtdhwrG0PzYq8&m=U08X0yMwV58yGbx93bkLeNZzM29_iUDJ2HMeH3VtbeQ&s=
qztHjfbjcJGZ0zmyjrv9Pmt0pZnB-rBM2GJ8ZUtOEgw&e=





From: "Thomas Garvey" <tgarvey@xxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Date: 09/11/2018 04:12 PM
Subject: Re: Viewing packed decimal field as a string
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Or you could get Stitch-in-Time

Best Regards,

Thomas Garvey


On 9/11/2018 11:32 AM, Dan wrote:
In that case, I like Rob's idea.

- Dan

On Tue, Sep 11, 2018 at 12:30 PM, Matt Olson <Matt.Olson@xxxxxxxx>
wrote:

I was hoping to do this in SQL so that I can then do a LIKE
'%12345%'
where 12345 is the string in the packed decimal field so I can
globally
find all string values across all tables that contain that packed
decimal
value.

I don't think that EXTJRNDTA would do that since it is on a file by
file
basis and would take days to go through hundreds of files on a file
by
file
basis like that.


--
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: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.
midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=

pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m=
U08X0yMwV58yGbx93bkLeNZzM29_iUDJ2HMeH3VtbeQ&s=JwUppna-
shtl4ydwfE5M1tF6q0sp0m6apfsmXlVxcZc&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://urldefense.proofpoint.com/v2/url?u=https-3A__
archive.midrange.com_midrange-2Dl&d=DwICAg&c=pApUd0AUA6FmKRo01iR_VA&r=


r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m=U08X0yMwV58yGbx93bkLeNZzM29_
iUDJ2HMeH3VtbeQ&s=_hcPh8Vd54FInk2K4wksV-VKOty1z0g7NcjeLikpYX0&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_
2dEadiD&d=DwICAg&c=pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_
ztz5b0wbCtdhwrG0PzYq8&m=U08X0yMwV58yGbx93bkLeNZzM29_iUDJ2HMeH3VtbeQ&s=
vrCsG6PDf6XxLikjXNplDcg-QjQ8RXGb4W1Ah08E5g8&e=


--
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: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.
midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=

pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m=
U08X0yMwV58yGbx93bkLeNZzM29_iUDJ2HMeH3VtbeQ&s=JwUppna-
shtl4ydwfE5M1tF6q0sp0m6apfsmXlVxcZc&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://urldefense.proofpoint.com/v2/url?u=https-3A__
archive.midrange.com_midrange-2Dl&d=DwICAg&c=pApUd0AUA6FmKRo01iR_VA&r=


r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m=U08X0yMwV58yGbx93bkLeNZzM29_
iUDJ2HMeH3VtbeQ&s=_hcPh8Vd54FInk2K4wksV-VKOty1z0g7NcjeLikpYX0&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_
2dEadiD&d=DwICAg&c=pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_
ztz5b0wbCtdhwrG0PzYq8&m=U08X0yMwV58yGbx93bkLeNZzM29_iUDJ2HMeH3VtbeQ&s=
vrCsG6PDf6XxLikjXNplDcg-QjQ8RXGb4W1Ah08E5g8&e=

--
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: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.
midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=
pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m=
5fzPK9rqCiyVfBL6_bYTAJv34oAJd2ynzjZVzr7-DKA&s=wbwmf1ZOXCQ7uWSJ3gTfy-
2XXeGR6y0eCrHiiRh3DJ4&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://urldefense.proofpoint.com/v2/url?u=https-3A__
archive.midrange.com_midrange-2Dl&d=DwICAg&c=pApUd0AUA6FmKRo01iR_VA&r=
r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m=5fzPK9rqCiyVfBL6_
bYTAJv34oAJd2ynzjZVzr7-DKA&s=24CJwFcrbKMYPsyQ28_
m3lA4jPR1jzNj_XdgMtXHJOY&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_
2dEadiD&d=DwICAg&c=pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_
ztz5b0wbCtdhwrG0PzYq8&m=5fzPK9rqCiyVfBL6_bYTAJv34oAJd2ynzjZVzr7-DKA&s=
Si5WHJRnEshz4zA5d7Uy9CGSMJjrpoEQzaXKZfqf87c&e=


--
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: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.
midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=
pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m=
5fzPK9rqCiyVfBL6_bYTAJv34oAJd2ynzjZVzr7-DKA&s=wbwmf1ZOXCQ7uWSJ3gTfy-
2XXeGR6y0eCrHiiRh3DJ4&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://urldefense.proofpoint.com/v2/url?u=https-3A__
archive.midrange.com_midrange-2Dl&d=DwICAg&c=pApUd0AUA6FmKRo01iR_VA&r=
r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m=5fzPK9rqCiyVfBL6_
bYTAJv34oAJd2ynzjZVzr7-DKA&s=24CJwFcrbKMYPsyQ28_
m3lA4jPR1jzNj_XdgMtXHJOY&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_
2dEadiD&d=DwICAg&c=pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_
ztz5b0wbCtdhwrG0PzYq8&m=5fzPK9rqCiyVfBL6_bYTAJv34oAJd2ynzjZVzr7-DKA&s=
Si5WHJRnEshz4zA5d7Uy9CGSMJjrpoEQzaXKZfqf87c&e=


As an Amazon Associate we earn from qualifying purchases.

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