RE: ROWID Problem with MaxDB 7.6 BETA Release

I believe ROWID is not part of the table but an artifact of the query result
(i.e. temporary query result table).  Your statement SELECT ROWID FROM TABLE
implies ROWID is an actual field when it is not.  A table with no primary
key has a hidden serial field called SYSKEY, but this is not ROWID.

SELECT AD_CLIENT_ID, ROWID
FROM AD_ACCESSLOG

would return a result in the ROWID result field.

If I am incorrect, someone please speak up.


Keith Arnold
The Boxer Group

-----Original Message-----
From: ubravo@xxxxxxxxxx [mailto:ubravo@xxxxxxxxxx]
Sent: Wednesday, March 30, 2005 3:11 PM
To: Keith
Subject: RE: ROWID Problem with MaxDB 7.6 BETA Release


Hello everybody
I hope this explain my problem.
First a want to create this table in SQL Studio - Oracle Mode for MaxDB 7.6
NOTE THAT FINISHED WITH ROWID STATEMENT
Create Table "AD_ACCESSLOG" (
        "AD_ACCESSLOG_ID" Integer NOT NULL ,
        "AD_CLIENT_ID" Integer NOT NULL ,
        "AD_ORG_ID" Integer NOT NULL ,
        "ISACTIVE" Char(1) NOT NULL  Default 'Y'  Constraint "SYS_C0017953" 
Check
(IsActive in ('Y','N')) ,
        "CREATED" Date NOT NULL  Default SYSDATE ,
        "CREATEDBY" Integer NOT NULL ,
        "UPDATED" Date NOT NULL  Default SYSDATE ,
        "UPDATEDBY" Integer NOT NULL ,
Primary Key ("AD_ACCESSLOG_ID")
)ROWID
Statement successfully executed. No Result
Execution Time:  15:23:46.703 - 15:23:46.749  (00.046 sec)

Then in the SQLStudio using MaxDB 7.5 Kernel get the next message
SELECT ROWID FROM AD_ACCESSLOG
Statement successfully executed. No Result
Execution Time:  15:25:25.203 - 15:25:25.233  (00.030 sec)
But when i try to do the same statement for MaxDB 7.6 it isn´t work and get
the
next message.

---- Error -------------------------------
Auto Commit: On, SQL Mode: Oracle, Isolation Level: Committed
 Column not found;-4005 POS(8) Unknown column name:ROWID
SELECT ROWID FROM AD_ACCESSLOG

ONLY WANT TO KNOW BECAUSE OF THIS?


Mensaje citado por Keith <keith@xxxxxxxxxxxxxxxxx>:

> I believe ubravo may be referring to the ROWNO predicate. Though the
> documentation states
> it can only be used in the WHERE clause, I have used it successfully in
the
> SELECT statement in 7.5 .
>
> Keith Arnold
> The Boxer Group
>
> -----Original Message-----
> From: Zabach, Elke [mailto:elke.zabach@xxxxxxx]
> Sent: Thursday, March 24, 2005 12:32 AM
> To: ubravo@xxxxxxxxxx; maxdb@xxxxxxxxxxxxxxx
> Subject: AW: ROWID Problem with MaxDB 7.6 BETA Release
>
>
> ubravo@xxxxxxxxxx wrote:
> >
> > I have a create table script that don´t get the rowid column in this
> > version
> > 7.6. Using SQLStudio to execute this script. Anyone can help me!! with
> > this
> > problem. Before I create this table the rowid column (Internal) doesn´t
> > exist.
> >
>
> Sorry, but I (and perhaps not only me) do not really understand your
> problem.
> Do you want to create a table or do you want to alter it?
> What do you mean with rowid-column? A column named ROWID, a datatype (not
> existing in MaxDB), the column named SYSKEY in MaxDB (the internal primary
> key if no user-defined one is specified) not ROWID as perhaps in the
> database system your were using before?
> Which error is returned? Your ' don´t get' is not very specific.
>
> Elke
> SAP Labs Berlin
>
> >
> >
> >
> >
> > --
> > 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=kba@xxxxxxxxxxxxxxxxx
>




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