Re: ROWID Problem with MaxDB 7.6 BETA Release

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