Bug: ArcSDE views created using sdetable -o create_view do not maintain -w clause definitions when attempting to view and query the layer
** This issue is addressed in ArcSDE 9.0 Service Pack 2 (SP2) **
ArcSDE views created with the sdetable -o create_view command are not maintaining the view definitions specified in the WHERE clause. This is seen when attempting to view and query the layer; the results include records that fall outside the WHERE clause parameters.
Click on the link in Related Information below to download the Service Pack, if necessary. **