Re: Viewing packed decimal field as a string -- MIDRANGE-L

Subject: Re: Viewing packed decimal field as a string
From: Rob Berendt <rob@xxxxxxxxx>
Date: Tue, 11 Sep 2018 16:17:48 -0400
List-archive: <https://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

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

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Viewing packed decimal field as a string , Gary Monnier

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.