By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,507 Members | 1,200 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,507 IT Pros & Developers. It's quick & easy.

generate UI from constraints

P: n/a
i've Googled some this morning, but to my surprise, i
don't find any offering (for fee or open source), which would
integrate with, say Jakarta Struts, to provide the UI
edits from cataloged constraints/triggers.

there have been some threads, even recently, dealing with
with the subject of where the "true" repository of data
integrity should be. the database is the answer of course, but
there needs to be some (easy) way to manage the constraints.

to give an example (no names, but the scenario is true): there is
this old COBOL/VSAM system "converted" to DB2. in the olde days,
constraints were housed in "tables" (a COBOL term of art) while
the data was in "files". these tables contained a bunch of
fields which constituted the "key" and some value, say, price
multiplier. so, the COBOL programs would sail along until they
had to process a "field" which is subject to a price multiplier; at
which point the "table" would be referenced, and the price
multiplier applied.

these "tables" were moved whole to DB2. they are really just
constraints; but they do have the advantage of being maintained
by the users kind of directly; given the depth of the count of
"key fields", tens of thousands of rows might exist for our
example price multiplier, so it's a pain, but it is viewable.

so, step one: generate the UI edits from the catalog
and step two: translate the user view of the constraints (the
"tables") back into constraints/triggers.

step two seems system specific. but step one seems a general
function, and thus amenable to commercialization. but i don't
find one. has anybody?

thx,
btdb

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.