skip to main content
Designing and coding the IP : Views : Views in Dynamic Schema configuration
 

Views in Dynamic Schema configuration

For a Dynamic Schema-based IP, you must set up the schema path in the OpenAccess SDK data source definition and copy the empty tables.csv and columns.csv files into the data source schema path.
The IP also must not return an error when IP SCHEMA is called with the table name set to the name of the view. This occurs when a CREATE VIEW or SELECT command is issued for a view. IP SCHEMA should return an error if a base object of the same name exists. Otherwise, it should return DAM_SUCCESS without adding any schema objects. All queries on views are translated to queries on base tables before calling IP EXECUTE.