RE: Tuple ID

Some databases have a unique system key (tupleid) regardless of the
existence of a primary key.  For SAPDB, the SYSKEY field is what I am
looking for.  Thank you for your assistance.

Keith Arnold

-----Original Message-----
From: Zabach, Elke [mailto:elke.zabach@xxxxxxx]
Sent: Friday, February 18, 2005 2:06 AM
To: Keith; Maxdb
Subject: AW: Tuple ID


Keith wrote:
>
> Is there a way to access the tuple id's in an SAPDB query statement?
>

Which tuple id ???

MaxDB' records have a primary key. If it was specified by the user using
the keywords PRIMARY KEY, then this is the unique identification of the
record.

If the user did not specify a primary key for the table, there is the
(implicit added) column named SYSKEY CHAR (8) BYTE, building the primary
key. This can be selected by explicit naming SELECT SYSKEY, .... FROM...

It will not be returned when using select *

Elke
SAP Labs Berlin

> Keith Arnold
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/maxdb?unsub=elke.zabach@xxxxxxx


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx