Query Netezza to find all tables in views
Check this Link and provide the error that its generated in your current query.

or its this query not returning data ? in that case maybe could be the where statement