[Unidata 8.2/RHEL] How can I fix an ODBC error that says "View is out of sync with base table"

Kevin,

I suspect the relevant dictionary entries that were used to create the view concerned have been modified since the views were created. Alternatively a view or dictionary from one location has been grafted into another where the dictionary does not match.  Whatever the chnges were, the view no longer matches the file dictionaey. Chck the file dictionary and also any change logs you might keep - worst case you may need to drop and recreate the view and re-grant access s appropriate.

Hoping this helps

JJ 

John, what is standard procedure for dropping and rebuilding the view.  Is that done with the SQL command at TCL or have better tools come about to do it (since the VSG is so gawd-awful).

Kevin,

You can use SQL commands at TCL to drop views - DROP VIEW view_name. The vatious command-line SQL commands are covered in the SQL reference guide. You can also use CONVERT.SQL file_name CHECKONLY which can be informative sometimes.

If using VSG to create views it is useful to display the SQL and save it. It can then be executed at the command lne if needed to re-create the original view(s) and also grant appropriate permissions at any time. I usually save the SQL statements in a PAragraph or PROC for ease off use.

Regards

JJ