PDA

View Full Version : 2 questions - remember I'm slow ...



dogfuel
05-05-2007, 09:09 AM
I have a physical table - some rows should not be visible in a business view. There is a single attriubte that determines this. How can I constrain the data in a BT with a where clause?

Is this on the conditions tab of Physical Table properties?

_________________________________________________________

Can I base a BT on a SQL statement rather than a physical table - there are reasons I don't want to use the DBMS to create a view, and would prefer to use a SQL?

Thanks

MattCasters
05-05-2007, 01:28 PM
We will be adding support for these things in the next version.
For the time being, consider writing views.

We have not added support for these features because we want to cater to the data warehouses first.

HTH,

Matt