Re: RPG and Binary

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Are all the records like that?
If so, I'd say you're mapping things wrong.  Do you by chance have any date
or time fields?


If not, are you perhaps looking at a journal entry that doesn't include the
record image?  (Look at the journal code and entry type)

Charles


On Fri, Jul 19, 2013 at 8:27 AM, Mike Cunningham <mike.cunningham@xxxxxxx>wrote:

> I have a table that was created with SQL and has 9.0 Binary data fields.
> Mostly used for record IDs. One of these fields/columns is used as an
> active/inactive switch and has either a 0 or a 1. If I use query to look at
> this file I see 0 and 1 on every record. I have an RPG program that reads
> the file directly and sees the same values. When I dump journal records for
> this table to a file and then map the JOESD field to a data structure of
> the table and read it in an RPG program it shows values like 0016777216 and
> 0016781171 and 000000000 .
>
> I am trying to analyze the journals to see when the value is ACTIVE is
> getting changed from 0 to 1 or 1 to 0
>
> Any ideas where I might have gone wrong?
> --
> 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.