Re: using systables in table constraint

In article <dennisp.788936662@infmx>, Dennis Pimple (dennisp@informix.com) writes: >An untried idea: > >Can a constraint be placed on a view? If so, create a view against >systables where tabid > 99, create a PK on the view.tabname, then >proceed. I'm not enough of a view expert to say this will positively >work, but maybe ... > We have found that you can NOT place a constraint on a view. Now we're look at doing a trigger/stored_procedure as an alternative. DAS -- Dave Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.21 UUCP: ..!uunet!das13!dave INTERNET: dave@das13.snide.com