Carlos Martinez wrote : > >On Wednesday 30 March 2005 10:49 pm, Keith wrote: >> 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] >I was using maxdb version 7.5 and creating tables in mode >Oracle using ROWID , >then I make a simple select stataments in Internal mode like >"Select rowid, >fieldname1, fieldname2,... from tablename " and I've got no >problems but when >using maxdb version 7.6 i've got "Unknown column name:ROWID" > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/maxdb?>[EMAIL PROTECTED] > >
I suppose you are running MaxDB in unicode mode with the 7.6 version, but in ascii mode with version 7.5. Unfortunately there's a bug inside both versions, which prevents the usage of the ROWID option in combination with unicode database instances. We will fix this bug as soon as possible. Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
