From: Anhaus, Thomas (thomas.anhaussap.com)
Date: Thu Mar 31 2005 - 02:08:31 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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: ubravoaullox.com [mailto:ubravoaullox.com]
>> 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 <keiththeboxergroup.com>:
>> > 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.zabachsap.com]
>> > Sent: Thursday, March 24, 2005 12:32 AM
>> > To: ubravoaullox.com; maxdblists.mysql.com
>> > Subject: AW: ROWID Problem with MaxDB 7.6 BETA Release
>> >
>> > ubravoaullox.com 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.zabachsap.com
>>
>> > --
>> > MaxDB Discussion Mailing List
>> > For list archives: http://lists.mysql.com/maxdb
>> > To unsubscribe:
>>
>> http://lists.mysql.com/maxdb?unsub=kbatheboxergroup.com
>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?>unsub=thomas.anhaussap.com
>
>

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]