Query Netezza to find all tables in views I am trying to recreate the following query in netezza and am struggling:

SELECT view_name, Table_Name
FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE
WHERE View_Name = '&lt;giveViewName&gt;'
ORDER BY view_name, table_name


Any tips on how to do this?
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