×
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.
Hello, Alan:
The SRCSTMF parameter has been available since at least V5R2 ...
Since the CRTxxxSQLI commands use a "preprocessor" to transform the
embedded SQL statements into "real" statements in the target language,
and then writes those statements into another source physical file
member (in QTEMP), perhaps there are some technical issues or reasons
why IBM does not yet provide the SRCSTMF capability for those SQL
precompiler commands ...?
*OIR Source Information is lost*
When you use SRCSTMF you will lose the "cross-reference" between the
object (*MODULE) and the source from which it was created.
I consider this to be one of thee most important features of i5/OS,
OS/400 and CPF ... the fact that the OS records the name of the source
file, library and member, and its date/time-stamp, in the "Object
Information Repository" (OIR) for the *MODULE. Almost no other
platforms have this capability built-in.
When you use SRCSTMF, the OIR information for source file/library/member
and date/time stamp fields are all* blank*. (That is, no source
information is stored in the OIR for the *MODULE.)
*DEBUG TEST issues*
While debugging, have you ever discovered that you were testing the
"wrong" version of a program? ("Oh, no, that NEVER happens in our shop!"
-- yeah, right.) How did you figure this out? Chances are pretty good
that you may have used the DSPPGM command to "drill down" to the *MODULE
level and see the date-time-stamp for the source member, to discover
that this version was not the "latest" ... :-o
*AUDIT concerns*
Consider the auditing concerns raised by using SRCSTMF. If you work for
a company that must comply with the Sarbanes-Oxley Act, or in the
banking sector, or air traffic control, or medical records, or almost
any industry where there are regulations concerning "business practices"
having to do with how you manage changes to critical applications. What
are the risks to the business if you cannot demonstrate "compliance"
with those regulations, and what are the associated costs (fines, etc.)?
*SUMMARY*
I have not yet found any compelling benefits to using SRCSTMF that
outweighs the risks associated with abandoning this important feature.
Sincerely,
Mark S. Waterbury
> Alan Campin wrote:
In release 5.4, IBM added the ability to compile from the IFS instead of
from an source member but I don't see the same thing on CRTSQLRPGI.
Does anyone know? Is there a way to do this or am I out of luck?
midrange.com
