|
Well, I have no way of testing this right now, but you *might* be able to peek into QSYS2/SYSPROCS to see defined procedures. I'm not really sure if that's the right file or not, but check it out and let me know. Eric DeLong -----Original Message----- From: Kellems, Cary [mailto:cary.kellems@nissan-usa.com] Sent: Thursday, April 19, 2001 4:26 PM To: 'MIDRANGE-L@midrange.com' Subject: RE: Restoring Stored procedures Eric, Thanks... this worked great. Is there anyway 'see' that the procedure exist? tia Cary > -----Original Message----- > From: DeLong, Eric [SMTP:EDeLong@Sallybeauty.com] > Sent: Thursday, April 19, 2001 10:40 AM > To: 'MIDRANGE-L@midrange.com' > Subject: RE: Restoring Stored procedures > > Operations navigator has the ability to run SQL scripts. Right click on > "Database" and you should have an option to "Run SQL Script". > > hth, > Eric DeLong > > -----Original Message----- > From: Kellems, Cary [mailto:cary.kellems@nissan-usa.com] > Sent: Thursday, April 19, 2001 10:55 AM > To: 'MIDRANGE-L@midrange.com' > Subject: Restoring Stored procedures > > > > Can anyone shed some light on how to restore a Stored procedure to a > system > that does not have the 'SQL Development Kit' installed. I have created > and > tested a stored procedure that uses an external RPGLE. I created the > "Create Procedure" via STRSQL but the remote machine does not have STRSQL. > I understood that this could be done. Any assistance would be > appreciated. > > +--- > | This is the Midrange System Mailing List! > | To submit a new message, send your mail to MIDRANGE-L@midrange.com. > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. > | To unsubscribe from this list send email to > MIDRANGE-L-UNSUB@midrange.com. > | Questions should be directed to the list owner/operator: > david@midrange.com > +--- > > +--- > | This is the Midrange System Mailing List! > | To submit a new message, send your mail to MIDRANGE-L@midrange.com. > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. > | To unsubscribe from this list send email to > MIDRANGE-L-UNSUB@midrange.com. > | Questions should be directed to the list owner/operator: > david@midrange.com > +--- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +--- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
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.