|
Thanks I had thought of that but I'm trying refcst for the first time in a fairly small (8-10 PF's probably 15-20 programs) and wanted to do AS MUCH AS IF NOT ALL error checking with refcst's if possible. As I said, this is kind of a "get your feet wet" thingie. Mark Allen I.S. Manager Wilkes Telephone & Electric A Dycom Company Phone: (706) 678-9565 Email: allenmark@nu-z.net http://www.nu-z.net :-----Original Message----- :From: midrange-l-admin@midrange.com :[mailto:midrange-l-admin@midrange.com] On Behalf Of :MWalter@hanoverwire.com :Sent: Thursday, May 09, 2002 12:38 PM :To: midrange-l@midrange.com :Subject: Re: ADDPFCST : : : :I'd probably do this with a *before *delete trigger. : : :Thanks, : :Mark : : :Mark Walter :Sr. Programmer/Analyst :Hanover Wire Cloth a div of CCX, Inc. :mwalter@hanoverwire.com :http://www.hanoverwire.com :717.637.3795 Ext.3040 : : : : Mark Allen : <allenmark@nu-z.net To: :midrange-l@midrange.com : > cc: : Sent by: Subject: ADDPFCST : midrange-l-admin@mi : drange.com : : : 05/09/02 02:36 PM : Please respond to : midrange-l : : : : : : :I've looked thru the manuals and the DB2UDB for iSeries :redbook and I don't see where it says it can't be done but no :examples either so I'll ask the esteemed list: : :I want a constraint where the record cannot be deleted if the :QTY field is not 0. Can this be done? How? : :Mark Allen :I.S. Manager :Wilkes Telephone & Electric :A Dycom Company :Phone: (706) 678-9565 :Email: allenmark@nu-z.net :http://www.nu-z.net : : : : :_______________________________________________ :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. : : : : : :_______________________________________________ :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. :
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.