× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I think you need to specify the RDB() parm as well.  Basically, the parms 
that are on CRTSQLPKG also exist on the CRTSQLRPGI command.  If you 
specify them the package will be created as part of the compile process.

At least that is my understanding.

Mark


midrange-l-bounces@xxxxxxxxxxxx wrote on 02/02/2005 03:49:46 PM:

> If this is true then I don't know the parm.
> The only package relevant parameter I'm aware of that I'm using is:
> SQLPKG *OBJ/*OBJLIB
> 
> Kurt
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Phippard
> Sent: Wednesday, February 02, 2005 2:01 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Do I have to recreate the SQLPKG, and why?
> 
> I thought that you just typically used the relevant parms on the
> CRTSQLRPGI command to create the package, then the package would be
> recreated as part of the recompile.
> 
> Mark
> 
> 
> midrange-l-bounces@xxxxxxxxxxxx wrote on 02/02/2005 02:43:46 PM:
> 
> > 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
> 
> 
> ________________________________________________________________________
> _____
> Scanned for SoftLanding Systems, Inc. by IBM Email Security Management
> Services powered by MessageLabs. 
> ________________________________________________________________________
> _____
> --
> 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 thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.