Re: PERFORM and fragmentation
> > From: Mark Steele <74431.3327@CompuServe.COM>
> I am trying to query a table in 7.01 using PERFORM in isql 4.10.
> When I try to generate a form a use it for a query, I receive the
> following errors:
>
> Rowids do not exist on the table
> The cursor or statement is not available
>
> Is this error caused by fragmenting the table across dbspaces?
>
>
I believe in 7.0 there is a statement:
ALTER TABLE tablename ADD ROWIDS
which adds the rowid column to fragmented tables.
**-------------------------+---------------------------**
|James Bennett | Phone: 916.891.5281 |
|Bi-Tech Software, Inc | Fax : 916.891.5011 |
|1072 Marauder, Suite A | EMail: james@bi-tech.com |
|Chico, CA 95926 | #include <disclaimer.h> |
| | #include <smartquote.h> |
**-------------------------+---------------------------**