|
RPG III triggers would have a problem with date/time data types but RPG IV works just fine. Scott Mildenberger > -----Original Message----- > From: SCarter@rsrcorp.com [mailto:SCarter@rsrcorp.com] > Sent: Friday, April 12, 2002 11:21 AM > To: midrange-l@midrange.com > Subject: Re: Cheaper Servers? > > > > I just want to ask is this a true statement? > We do not have the SQL Toolkit we are on V5R1 and have not > used many triggers on the DB files. > One thing that struck me as odd is the statement that RPG > could not handle > the date and time data types or null values. > > > "I am asking this question because the old Load Schedule used system > triggers that I wrote in RPG to autoincrement primary keys. > I tried the > same technique for the J2EE version of the Load Schedule, but > it does not > work because the new tables use date and time data types (so > that it is > easier to work with Java) and because of null values." > > > Also, what is the prefered method for writing triggers? RPG, SQL > > ________________
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.