Progress
DataServer
for ODBC Guide
Modifying Tables to Support the ROWID Function
If you want to use the ROWID function with an ODBC data source, you must make certain changes to your data-source table. The following example procedure for a Sybase and SQL Server 6 illustrates how to do this.
To use the ROWID function with a stored procedure using a similar syntax, first check your data source to see if it supports stored procedures. With a Sybase database, make the following changes to your data-source table:
- Add a column of the integer data type named PROGRESS_RECID. The new column must be able to contain null:
- Add a column with identity characteristics named PROGRESS_RECID_IDENT_. The new column must have the numeric data type:
- Create a trigger to maintain the PROGRESS_RECID column:
- Change the nonunique indexes so that they include a PROGRESS_RECID column as the last component:
- If you have already created your schema holder, update it to reflect your changes to the data-source table.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |