AW: ROWID Problem with MaxDB 7.6 BETA Release

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: 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
>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.anhaus@xxxxxxx
>
>

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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx