Monday, March 10, 2008

Where are your custom TEP queries?

If you are wondering where your custom TEP view queries are stored, wonder no more. No, they are not stored in .sql files on TEPS...

Your custom view queries on TEP are stored in the TEPS RDBMS in the KFWQUERY table. The name you gave the query is in the 'NAME' column and your sql statement can be found in the 'QUERY' column at \@sql='.

This applies only to queries created within the TEP directly, not the UA ODBC data provider. One downfall with writing queries from inside of a TEP view is that there are no attributes in the data, so you can't write a situation to monitor the result sets. Check back later for more on where queries are stored when written for the UA.

No comments: