Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

adding a GUID column

7 posts in General Discussion Last posting was on 2003-08-04 13:28:23.0Z
D.Ahmed Posted on 2003-07-31 16:54:11.0Z
Reply-To: "D.Ahmed" <forums.sybase.com>
From: "D.Ahmed" <dabdurazack@siemens-hearing.com>
Newsgroups: ianywhere.public.general
Subject: adding a GUID column
Lines: 9
Organization: Siemens Hearing Instruments
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: host71.siemens-hearing.com
X-Original-NNTP-Posting-Host: host71.siemens-hearing.com
Message-ID: <3f2949b3@forums-1-dub>
Date: 31 Jul 2003 09:54:11 -0700
X-Trace: forums-1-dub 1059670451 65.192.162.71 (31 Jul 2003 09:54:11 -0700)
X-Original-Trace: 31 Jul 2003 09:54:11 -0700, host71.siemens-hearing.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1491
Article PK: 3721

Hi

I am planning to add a column in a table which will hold a GUID. What is
data type I should be using ? We are presently working on ASA 7.0.3.2057

Thanks,
DAN


Shuchit Velkar Posted on 2003-08-01 00:36:36.0Z
Newsgroups: ianywhere.public.general
Subject: Re: adding a GUID column
From: Shuchit Velkar <me@privacy.net>
References: <3f2949b3@forums-1-dub>
Message-ID: <Xns93C9B282FD192svelkarNOsybaseSPAMc@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: svelkar-pc.sybase.com
X-Original-NNTP-Posting-Host: svelkar-pc.sybase.com
Date: 31 Jul 2003 17:36:36 -0700
X-Trace: forums-1-dub 1059698196 10.22.46.156 (31 Jul 2003 17:36:36 -0700)
X-Original-Trace: 31 Jul 2003 17:36:36 -0700, svelkar-pc.sybase.com
Lines: 24
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1498
Article PK: 3728

"D.Ahmed" <dabdurazack@siemens-hearing.com> wrote in news:3f2949b3@forums-
1-dub:

> Hi
>
> I am planning to add a column in a table which will hold a GUID. What is
> data type I should be using ? We are presently working on ASA 7.0.3.2057
>
> Thanks,
> DAN
>
>

Binary(16)

Asa 8.0.2 defines a new data type UNIQUEIDENTIFIER
for storing GUIDs, which is defined as Binary(16).
8.0.2 also adds functions for generating new GUIDs,
converting GUIDs to and from strings.

--
Shuchit Velkar
Professional Services
iAnywhere Solutions


DAN Posted on 2003-08-02 13:58:18.0Z
Reply-To: "DAN" <forums.sybase.com>
From: "DAN" <dabdurazack@siemens-hearing.com>
Newsgroups: ianywhere.public.general
References: <3f2949b3@forums-1-dub> <Xns93C9B282FD192svelkarNOsybaseSPAMc@10.22.241.106>
Subject: Re: adding a GUID column
Lines: 37
Organization: Siemens Hearing Instruments
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: host71.siemens-hearing.com
X-Original-NNTP-Posting-Host: host71.siemens-hearing.com
Message-ID: <3f2bc37a$1@forums-1-dub>
Date: 2 Aug 2003 06:58:18 -0700
X-Trace: forums-1-dub 1059832698 65.192.162.71 (2 Aug 2003 06:58:18 -0700)
X-Original-Trace: 2 Aug 2003 06:58:18 -0700, host71.siemens-hearing.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1509
Article PK: 3739

Mr. Suchit

Does your suggestion hold good for the version ASA 7.0.3.2057 ? As I have
mentioned that we are presently working on this version.

Thanks,

DAN

"Shuchit Velkar" <me@privacy.net> wrote in message
news:Xns93C9B282FD192svelkarNOsybaseSPAMc@10.22.241.106...
> "D.Ahmed" <dabdurazack@siemens-hearing.com> wrote in news:3f2949b3@forums-
> 1-dub:
>
> > Hi
> >
> > I am planning to add a column in a table which will hold a GUID. What is
> > data type I should be using ? We are presently working on ASA 7.0.3.2057
> >
> > Thanks,
> > DAN
> >
> >
>
> Binary(16)
>
> Asa 8.0.2 defines a new data type UNIQUEIDENTIFIER
> for storing GUIDs, which is defined as Binary(16).
> 8.0.2 also adds functions for generating new GUIDs,
> converting GUIDs to and from strings.
>
> --
> Shuchit Velkar
> Professional Services
> iAnywhere Solutions


Breck Carter [TeamSybase] Posted on 2003-08-02 16:37:48.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: adding a GUID column
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <3gpnivs2aan95jv2678n51cbc2nimm7u66@4ax.com>
References: <3f2949b3@forums-1-dub> <Xns93C9B282FD192svelkarNOsybaseSPAMc@10.22.241.106> <3f2bc37a$1@forums-1-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 2 Aug 2003 09:37:48 -0700
X-Trace: forums-1-dub 1059842268 64.7.134.118 (2 Aug 2003 09:37:48 -0700)
X-Original-Trace: 2 Aug 2003 09:37:48 -0700, bcarter.sentex.ca
Lines: 58
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1510
Article PK: 3740

Perhaps the question you should ask is "How can I get a GUID value in
ASA 7?"... the NEWID function, the STRTOUUID function and the
UUIDTOSTR function were all introduced in Version 8.0.2.

The new "data type" called UNIQUEIDENTIFIER is just a domain defined
as BINARY ( 16 ). In ASA version 9, the UNIQUEIDENTIFIERSTR domain has
been introduced as CHAR ( 36 ).

You can use either BINARY ( 16 ) or CHAR ( 36 ) depending on whether
you want to store the internal or display versions of a GUID. But
you're on your own as far as filling in the values, unless you
upgrade.

Breck

On 2 Aug 2003 06:58:18 -0700, "DAN" <dabdurazack@siemens-hearing.com>

wrote:

>Mr. Suchit
>
>Does your suggestion hold good for the version ASA 7.0.3.2057 ? As I have
>mentioned that we are presently working on this version.
>
>Thanks,
>
>DAN
>
>"Shuchit Velkar" <me@privacy.net> wrote in message
>news:Xns93C9B282FD192svelkarNOsybaseSPAMc@10.22.241.106...
>> "D.Ahmed" <dabdurazack@siemens-hearing.com> wrote in news:3f2949b3@forums-
>> 1-dub:
>>
>> > Hi
>> >
>> > I am planning to add a column in a table which will hold a GUID. What is
>> > data type I should be using ? We are presently working on ASA 7.0.3.2057
>> >
>> > Thanks,
>> > DAN
>> >
>> >
>>
>> Binary(16)
>>
>> Asa 8.0.2 defines a new data type UNIQUEIDENTIFIER
>> for storing GUIDs, which is defined as Binary(16).
>> 8.0.2 also adds functions for generating new GUIDs,
>> converting GUIDs to and from strings.
>>
>> --
>> Shuchit Velkar
>> Professional Services
>> iAnywhere Solutions
>

bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
http://www.risingroad.com


DAN Posted on 2003-08-03 15:26:20.0Z
Reply-To: "DAN" <forums.sybase.com>
From: "DAN" <dabdurazack@siemens-hearing.com>
Newsgroups: ianywhere.public.general
References: <3f2949b3@forums-1-dub> <Xns93C9B282FD192svelkarNOsybaseSPAMc@10.22.241.106> <3f2bc37a$1@forums-1-dub> <3gpnivs2aan95jv2678n51cbc2nimm7u66@4ax.com>
Subject: Re: adding a GUID column
Lines: 70
Organization: Siemens Hearing Instruments
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: host71.siemens-hearing.com
X-Original-NNTP-Posting-Host: host71.siemens-hearing.com
Message-ID: <3f2d299c$1@forums-1-dub>
Date: 3 Aug 2003 08:26:20 -0700
X-Trace: forums-1-dub 1059924380 65.192.162.71 (3 Aug 2003 08:26:20 -0700)
X-Original-Trace: 3 Aug 2003 08:26:20 -0700, host71.siemens-hearing.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1513
Article PK: 3743

Thanks Breck.
Say I used CHAR(36) and in future if we plan to move to ASA 8 or 9, how
sould I proceed ? Will this effect replication ? We are currently using SQL
Remote/File based technique.

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:3gpnivs2aan95jv2678n51cbc2nimm7u66@4ax.com...
> Perhaps the question you should ask is "How can I get a GUID value in
> ASA 7?"... the NEWID function, the STRTOUUID function and the
> UUIDTOSTR function were all introduced in Version 8.0.2.
>
> The new "data type" called UNIQUEIDENTIFIER is just a domain defined
> as BINARY ( 16 ). In ASA version 9, the UNIQUEIDENTIFIERSTR domain has
> been introduced as CHAR ( 36 ).
>
> You can use either BINARY ( 16 ) or CHAR ( 36 ) depending on whether
> you want to store the internal or display versions of a GUID. But
> you're on your own as far as filling in the values, unless you
> upgrade.
>
> Breck
>
> On 2 Aug 2003 06:58:18 -0700, "DAN" <dabdurazack@siemens-hearing.com>
> wrote:
>
> >Mr. Suchit
> >
> >Does your suggestion hold good for the version ASA 7.0.3.2057 ? As I have
> >mentioned that we are presently working on this version.
> >
> >Thanks,
> >
> >DAN
> >
> >"Shuchit Velkar" <me@privacy.net> wrote in message
> >news:Xns93C9B282FD192svelkarNOsybaseSPAMc@10.22.241.106...
> >> "D.Ahmed" <dabdurazack@siemens-hearing.com> wrote in
news:3f2949b3@forums-
> >> 1-dub:
> >>
> >> > Hi
> >> >
> >> > I am planning to add a column in a table which will hold a GUID. What
is
> >> > data type I should be using ? We are presently working on ASA
7.0.3.2057
> >> >
> >> > Thanks,
> >> > DAN
> >> >
> >> >
> >>
> >> Binary(16)
> >>
> >> Asa 8.0.2 defines a new data type UNIQUEIDENTIFIER
> >> for storing GUIDs, which is defined as Binary(16).
> >> 8.0.2 also adds functions for generating new GUIDs,
> >> converting GUIDs to and from strings.
> >>
> >> --
> >> Shuchit Velkar
> >> Professional Services
> >> iAnywhere Solutions
> >
>
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> http://www.risingroad.com


Breck Carter [TeamSybase] Posted on 2003-08-03 19:41:58.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: adding a GUID column
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <fnoqivg5sf688124vge03etn5732a8v8l7@4ax.com>
References: <3f2949b3@forums-1-dub> <Xns93C9B282FD192svelkarNOsybaseSPAMc@10.22.241.106> <3f2bc37a$1@forums-1-dub> <3gpnivs2aan95jv2678n51cbc2nimm7u66@4ax.com> <3f2d299c$1@forums-1-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 65.82.140.70
X-Original-NNTP-Posting-Host: 65.82.140.70
Date: 3 Aug 2003 12:41:58 -0700
X-Trace: forums-1-dub 1059939718 65.82.140.70 (3 Aug 2003 12:41:58 -0700)
X-Original-Trace: 3 Aug 2003 12:41:58 -0700, 65.82.140.70
Lines: 94
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1515
Article PK: 3745

It's just data, there is nothing special about GUIDs other than the
way the values are generated. CHAR(36) is the fat human-readable
hex-in-character-format version, including dashes '-' to separate
sections. BINARY(16) is the slender version that NEWID generates
directly. IMO GUIDs suck as identifiers, in *general*... GLOBAL
AUTOINCREMENT is wayyyy nicer. Having said that, I *do* use a GUID to
generate an initial value of remote database identifier (MobiLink user
name) so that no administration effort is required. But once it is
uploaded, it gets changed to an AUTOINCREMENT number since numbers 1,
2, 3 are easier for administrators to deal with over the long term;
staring at a MobiLink monitor screen where the user names are GUIDs
would be beyond the pale :)

Soooooo, what do *you* want to use a GUID for? I *am* interested; they
are new to me, and I am interested in what they would be good for.

Breck

On 3 Aug 2003 08:26:20 -0700, "DAN" <dabdurazack@siemens-hearing.com>

wrote:

>Thanks Breck.
>Say I used CHAR(36) and in future if we plan to move to ASA 8 or 9, how
>sould I proceed ? Will this effect replication ? We are currently using SQL
>Remote/File based technique.
>
>"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
>message news:3gpnivs2aan95jv2678n51cbc2nimm7u66@4ax.com...
>> Perhaps the question you should ask is "How can I get a GUID value in
>> ASA 7?"... the NEWID function, the STRTOUUID function and the
>> UUIDTOSTR function were all introduced in Version 8.0.2.
>>
>> The new "data type" called UNIQUEIDENTIFIER is just a domain defined
>> as BINARY ( 16 ). In ASA version 9, the UNIQUEIDENTIFIERSTR domain has
>> been introduced as CHAR ( 36 ).
>>
>> You can use either BINARY ( 16 ) or CHAR ( 36 ) depending on whether
>> you want to store the internal or display versions of a GUID. But
>> you're on your own as far as filling in the values, unless you
>> upgrade.
>>
>> Breck
>>
>> On 2 Aug 2003 06:58:18 -0700, "DAN" <dabdurazack@siemens-hearing.com>
>> wrote:
>>
>> >Mr. Suchit
>> >
>> >Does your suggestion hold good for the version ASA 7.0.3.2057 ? As I have
>> >mentioned that we are presently working on this version.
>> >
>> >Thanks,
>> >
>> >DAN
>> >
>> >"Shuchit Velkar" <me@privacy.net> wrote in message
>> >news:Xns93C9B282FD192svelkarNOsybaseSPAMc@10.22.241.106...
>> >> "D.Ahmed" <dabdurazack@siemens-hearing.com> wrote in
>news:3f2949b3@forums-
>> >> 1-dub:
>> >>
>> >> > Hi
>> >> >
>> >> > I am planning to add a column in a table which will hold a GUID. What
>is
>> >> > data type I should be using ? We are presently working on ASA
>7.0.3.2057
>> >> >
>> >> > Thanks,
>> >> > DAN
>> >> >
>> >> >
>> >>
>> >> Binary(16)
>> >>
>> >> Asa 8.0.2 defines a new data type UNIQUEIDENTIFIER
>> >> for storing GUIDs, which is defined as Binary(16).
>> >> 8.0.2 also adds functions for generating new GUIDs,
>> >> converting GUIDs to and from strings.
>> >>
>> >> --
>> >> Shuchit Velkar
>> >> Professional Services
>> >> iAnywhere Solutions
>> >
>>
>> bcarter@risingroad.com
>> Mobile and Distributed Enterprise Database Applications
>> http://www.risingroad.com
>

bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
http://www.risingroad.com


DAN Posted on 2003-08-04 13:28:23.0Z
Reply-To: "DAN" <forums.sybase.com>
From: "DAN" <dabdurazack@siemens-hearing.com>
Newsgroups: ianywhere.public.general
References: <3f2949b3@forums-1-dub> <Xns93C9B282FD192svelkarNOsybaseSPAMc@10.22.241.106> <3f2bc37a$1@forums-1-dub> <3gpnivs2aan95jv2678n51cbc2nimm7u66@4ax.com> <3f2d299c$1@forums-1-dub> <fnoqivg5sf688124vge03etn5732a8v8l7@4ax.com>
Subject: Re: adding a GUID column
Lines: 120
Organization: Siemens Hearing Instruments
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: host71.siemens-hearing.com
X-Original-NNTP-Posting-Host: host71.siemens-hearing.com
Message-ID: <3f2e5f77$1@forums-1-dub>
Date: 4 Aug 2003 06:28:23 -0700
X-Trace: forums-1-dub 1060003703 65.192.162.71 (4 Aug 2003 06:28:23 -0700)
X-Original-Trace: 4 Aug 2003 06:28:23 -0700, host71.siemens-hearing.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1519
Article PK: 3749

We are using GUID in two areas. Basically we do not have choice, except to
go with it. I will explain you one.

Our application (Patients maintenance,OMS) can be installed as different
installations (for Hospitals) with each installation having its own
replication setup.
We just introduced a feature that data (patients/patients data) to be sent
from one installed site (Hospital) to another, using XML. Users need to know
where the data (patient) originated from or to have a trace of travel. To
acomplish this we have whats called a site registeration at each site which
will recognize each site by generating a GUID.

Since we are in a plan to go 8.0.2, we are unable to use the good GUID /
AUTOINCREMENT features of ASA 8.

Thanks :),
DAN

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:fnoqivg5sf688124vge03etn5732a8v8l7@4ax.com...
> It's just data, there is nothing special about GUIDs other than the
> way the values are generated. CHAR(36) is the fat human-readable
> hex-in-character-format version, including dashes '-' to separate
> sections. BINARY(16) is the slender version that NEWID generates
> directly. IMO GUIDs suck as identifiers, in *general*... GLOBAL
> AUTOINCREMENT is wayyyy nicer. Having said that, I *do* use a GUID to
> generate an initial value of remote database identifier (MobiLink user
> name) so that no administration effort is required. But once it is
> uploaded, it gets changed to an AUTOINCREMENT number since numbers 1,
> 2, 3 are easier for administrators to deal with over the long term;
> staring at a MobiLink monitor screen where the user names are GUIDs
> would be beyond the pale :)
>
> Soooooo, what do *you* want to use a GUID for? I *am* interested; they
> are new to me, and I am interested in what they would be good for.
>
> Breck
>
> On 3 Aug 2003 08:26:20 -0700, "DAN" <dabdurazack@siemens-hearing.com>
> wrote:
>
> >Thanks Breck.
> >Say I used CHAR(36) and in future if we plan to move to ASA 8 or 9, how
> >sould I proceed ? Will this effect replication ? We are currently using
SQL
> >Remote/File based technique.
> >
> >"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> >message news:3gpnivs2aan95jv2678n51cbc2nimm7u66@4ax.com...
> >> Perhaps the question you should ask is "How can I get a GUID value in
> >> ASA 7?"... the NEWID function, the STRTOUUID function and the
> >> UUIDTOSTR function were all introduced in Version 8.0.2.
> >>
> >> The new "data type" called UNIQUEIDENTIFIER is just a domain defined
> >> as BINARY ( 16 ). In ASA version 9, the UNIQUEIDENTIFIERSTR domain has
> >> been introduced as CHAR ( 36 ).
> >>
> >> You can use either BINARY ( 16 ) or CHAR ( 36 ) depending on whether
> >> you want to store the internal or display versions of a GUID. But
> >> you're on your own as far as filling in the values, unless you
> >> upgrade.
> >>
> >> Breck
> >>
> >> On 2 Aug 2003 06:58:18 -0700, "DAN" <dabdurazack@siemens-hearing.com>
> >> wrote:
> >>
> >> >Mr. Suchit
> >> >
> >> >Does your suggestion hold good for the version ASA 7.0.3.2057 ? As I
have
> >> >mentioned that we are presently working on this version.
> >> >
> >> >Thanks,
> >> >
> >> >DAN
> >> >
> >> >"Shuchit Velkar" <me@privacy.net> wrote in message
> >> >news:Xns93C9B282FD192svelkarNOsybaseSPAMc@10.22.241.106...
> >> >> "D.Ahmed" <dabdurazack@siemens-hearing.com> wrote in
> >news:3f2949b3@forums-
> >> >> 1-dub:
> >> >>
> >> >> > Hi
> >> >> >
> >> >> > I am planning to add a column in a table which will hold a GUID.
What
> >is
> >> >> > data type I should be using ? We are presently working on ASA
> >7.0.3.2057
> >> >> >
> >> >> > Thanks,
> >> >> > DAN
> >> >> >
> >> >> >
> >> >>
> >> >> Binary(16)
> >> >>
> >> >> Asa 8.0.2 defines a new data type UNIQUEIDENTIFIER
> >> >> for storing GUIDs, which is defined as Binary(16).
> >> >> 8.0.2 also adds functions for generating new GUIDs,
> >> >> converting GUIDs to and from strings.
> >> >>
> >> >> --
> >> >> Shuchit Velkar
> >> >> Professional Services
> >> >> iAnywhere Solutions
> >> >
> >>
> >> bcarter@risingroad.com
> >> Mobile and Distributed Enterprise Database Applications
> >> http://www.risingroad.com
> >
>
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> http://www.risingroad.com