RE: int vs binary questions

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Hans Boldt
Sent: Monday, February 09, 2004 12:41 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: int vs binary questions


>Steve Richter wrote:
>> is there a dds equivalent to "10i 0"?

> The DDS equivalent is 9b0, but you also have to code
> EXTBININT(*YES) on
> your H-Spec to map binary fields (with 0 decimal places) to integer.

sounds risky.  pgma uses extbinint(*yes) and stores *hival in a binary
database field.  PGMB uses the default EXTBININT(*NO) and tests the binary
database field for *hival.  The compare will not return *equal, correct?

>Also, if I'm not mistaken, any B field defined in DDS with more than 9
>digits is automatically defined as I in the RPG program, regardless of
>any EXTBININT keyword.

just did a test and that is correct.  however, the 10b 0 database field is 8
bytes in size and maps to an "i20 0" rpg fld.

now I am curious how SQL treats database binary fields.  esp when RPG uses
EXTBININT(*YES).

-Steve