|
Frances, As an addition to the use of RUNSQLSTM: most, if not any, SQL statements kept in a SRCPF (length 91) can be turned into a QM Query object with the CRTQMQRY command. You do not have the SQL Dev Kit installed, either. Regards, Carel Teijgeler. *********** REPLY SEPARATOR *********** On 20-4-05 at 15:18 Frances Denoncourt wrote: >Thanks to those who responded. Rob, I think we agree with you. We want >visibility on the source. > >We tried the source member route. That worked. I created a stored >procedure using the RUNSQLSTM and it created a C *pgm. Now the cool >thing is that we don't have the SQL dev kit installed. <SNIP> >If we had to, I suppose we could use WRKDBF on the production machine >to add 'source' members and then create the stored procedures from that. > >While we were plunking around trying to find the objects created by the >create procedure command, we noticed we had to delete an existing one to >recreate the stored procedure.
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.
midrange.com
