Re: Integer type in DDS PF?

Justin,

It may help shed some light on the subject to know why "4" vs. "9" --


That is the number of decimal digits that will fit into an integer of that size (2 bytes or 4 bytes) "safely" (e.g. without any truncation).   

Mark S. Waterbury

On Thursday, September 19, 2019, 10:15:03 AM EDT, Robert Rogerson <rogersonra@xxxxxxxxx> wrote:

Justin, the equivalent of an sql SMALLINT is 4B 0 and an sql INTEGER is 9B
0.

On Thu, Sep 19, 2019 at 9:57 AM Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

I defined my column in the DDS as " 4B 0" and thought all was well.
Today, I happened to be looking in iACS, and it shows the data type as
SMALLINT instead of INTEGER.  Does the DDS need 8B instead?

Thanks



-----Original Message-----
From: Justin Taylor
Sent: Tuesday, September 17, 2019 7:55 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx

Subject: RE: Integer type in DDS PF?

I had a vague recollection of defining integers 4 long binary in RPG long
ago, but wasn't positive.  Thank you



-----Original Message-----
From: Robert Rogerson [mailto:rogersonra@xxxxxxxxx]
Sent: Monday, September 16, 2019 4:20 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Integer type in DDS PF?

An sql integer is 9B 0 which uses 4 bytes of storage.

Rob


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com