RE: Storing Guids in DB2/400

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

Walden,

How could you possibly check that it's a valid GUID?

All the GUID is is a 16 byte number, right?  Conceivably, everything
from x'00000000000000000000000000000000' to
x'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' is valid.

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden 
> H. Leverich
> Sent: Wednesday, November 08, 2006 2:41 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Storing Guids in DB2/400
>
> > ...have you thought of using a SEQUENCE?
>
> Actually this is a Guid coming from external systems (both 
> Java and .NET
> Guids will be involved here) and they're being used as 
> foreign keys. I'm
> thinking the right type is a char(16) for bit data, but then I need to
> do the translation from the Guid to the byte array myself. 
> Char(36) lets
> me just store the guid, but there's no checking that it's a 
> valid guid.
>
> -Walden
>
> -- 
> Walden H Leverich III
> Tech Software
> (516) 627-3800 x3051
> WaldenL@xxxxxxxxxxxxxxx
> http://www.TechSoftInc.com
>
> Quiquid latine dictum sit altum viditur.
> (Whatever is said in Latin seems profound.)
>
> -- 
> 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.