Re: SQL help

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

Converting programmatic RI to constraints seems it'd be a daunting task.
Has anyone done it all the way through? I mean, some of the code would be
leaner, but there are new messages to respond to, etc.

At 02:11 PM 4/24/02 -0400, you wrote:
> >In other words, in order to send a message
> >such: "an order item is being loaded while
> >no order exist" you need to know the constraint
> >details, is that true ?
>
>As far as I know, that's true.  I tried to create a general purpose routine
>to make nice messages by using catalogue file SYSCST and the constraint name
>from the file INFDS, but I never finished it.
>
>We're using Synon here for almost all of our work, and the CASE tool
>enforces RI through program code.  Setting RI constraints here is really to
>prohibit DFU users from 'accidentally' corrupting the data.
>
>   --buck
>
>"This box Rocks!" - related to 2002 NE IBM
>Conference attendees by IBM's Stephanie Joy
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.