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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>: > 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:[EMAIL PROTECTED] > Sent: Thursday, March 24, 2005 12:32 AM > To: [EMAIL PROTECTED]; [email protected] > Subject: AW: ROWID Problem with MaxDB 7.6 BETA Release > > > [EMAIL PROTECTED] 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/[EMAIL PROTECTED] > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
