RE: One byte integer

If the Incredible Hulk was a programmer, I'm sure he'd use PUNYINT.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby
Sent: Monday, March 25, 2013 11:04 AM
To: Midrange Systems Technical Discussion
Subject: Re: One byte integer

What's after TINYINT. PUNYINT?

:)


On Mon, Mar 25, 2013 at 11:49 AM, Raul A. Jager W. <raul@xxxxxxxxxx> wrote:

Yes, my memmory had some reference to TINYINT, but I could not find it
in DB2/400.
Now I know I must stop locking for it, and use other option.
Thanks, now I can continue to avance my project.
Raúl

Scott Klement wrote:

In some flavors of SQL there's a data type of TINYINT, which seems to
be what Raul is looking for.

Unfortunately, this doesn't exist in DB2 for i.


On 3/25/2013 9:24 AM, Luis Rodriguez wrote:

IIRC, the smallest integer field you can specify in SQL is SMALLINT,

which

is defined as (again, IIRC) as a two(2) bytes field.

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

--
Jeff Crosby
VP Information Systems
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531
www.dilgardfoods.com

The opinions expressed are my own and not necessarily the opinion of my company. Unless I say so.
--
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.