Kbase P62502: How to transfer a subset of data via ODBC when application d
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/14/2004 |
|
Status: Unverified
GOAL:
How to transfer a subset of data via ODBC when application doing the transfer does not (and cannot) use the WHERE clause of the SELECT statement
FIX:
To get past the third party applications limitations, create a view using the CREATE VIEW statement. The view should be a SELECT * FROM SomeTable statement and should have a WHERE clause that limits the results to only the required records