|
If you override the create command, or attach a pre/post run command just once in TurnOver, it will remember those overrides from that point forward. So typically, you can just do this in development and get it right, then have it carried forward as you promote. Mark midrange-l-bounces@xxxxxxxxxxxx wrote on 02/02/2005 03:41:56 PM: > I could do that, but it'd be a on form per form basis, right? (I > haven't used that function of Turnover personally). > > What I'd like to do is have it so a programmer isn't expected to check > all programs that are getting recompiled to see if one happens to have a > SQLPKG (or so they aren't expected to consult a documented list of > programs with SQLPKGs). > > -----Original Message----- > From: midrange-l-bounces@xxxxxxxxxxxx > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx > Sent: Wednesday, February 02, 2005 1:44 PM > To: Midrange Systems Technical Discussion > Subject: Re: Do I have to recreate the SQLPKG, and why? > > A workaround might be to have Turnover do a "Post Run" command to create > the package. > > Rob Berendt > -- > Group Dekko Services, LLC > Dept 01.073 > PO Box 2000 > Dock 108 > 6928N 400E > Kendallville, IN 46755 > http://www.dekko.com > > > > > > "Kurt Anderson" <kjanderson@xxxxxxxxxxxxx> > Sent by: midrange-l-bounces+rob=dekko.com@xxxxxxxxxxxx > 02/02/2005 01:50 PM > Please respond to > Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> > > > To > "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx> > cc > > Subject > Do I have to recreate the SQLPKG, and why? > > > > > > > I have a SQLRPG program that has to access files created by a software > vendor which reside on a separate box. We do have DDMs for those files, > but not with a key I need. So I did a little research and found that I > could create a SQL Package which would allow me to perform embedded SQL > statements across systems. > > >From what I've found, I need to have the SQLPKG reside on the system my > program is using SQL to get to. It seems that I must recreate the > SQLPKG any time the object that references it is recompiled. This > wasn't so bad originally, but as time goes on, if any of our database > files change that this program uses, Turnover (our change management > software) will recompile the program, but the SQLPKG remains as it was. > When this happens, and someone calls the program, they get a > data-decimal error. Once I recreate the SQLPKG the error goes away. > > Is there a compile parameter I can specify that would prevent this error > from occurring? > Why is this error occurring? (Ok, I understand that a numeric field has > non-numeric data in it... but what is causing that?) > > Thanks, > > Kurt Anderson > Application Developer > Highsmith Inc. > W5527 State Road 106, P.O. Box 800 > Fort Atkinson, WI 53538-0800 > TEL (920) 563-9571 FAX (920) 563-7395 > EMAIL kjanderson@xxxxxxxxxxxxx > > -- > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing > list > To post a message email: MIDRANGE-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > 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@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > 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@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > > > _____________________________________________________________________________ > Scanned for SoftLanding Systems, Inc. by IBM Email Security Management > Services powered by MessageLabs. > _____________________________________________________________________________ _____________________________________________________________________________ Scanned for SoftLanding Systems, Inc. by IBM Email Security Management Services powered by MessageLabs. _____________________________________________________________________________
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.