QlikView application should point to new schema tables instead of the data files

[Anonymous]

Hi

presently our qlikview application is using source data files and new requirement is to use schema table..... data is same but it should fetch from schema tables....

[rwunderlich]

What is a "schema table"?  It's not a term I'm understanding in this context.

-Rob

[Anonymous]

A database schema is the skeleton structure that represents the logical view of the entire database.

[rwunderlich]

You can access the catalog schema using the SQLTABLES script statement.  What I didn't understand was your statement "data is same..."

-Rob

[Anonymous]

Hi,

I want to connect Materialised views in database to an existing qlikview QVW. How should I point to Materialised views instead of Qvd.

[rwunderlich]

SQL SELECT?