Re: Include file PATH question

[Nathan Stratton Treadway <nathant@ONTKO.COM>]

On Mon, Feb 05, 2001 at 04:27:28PM -0800, Benjamin Le wrote:
> How does SQR search the path of INCLUDE files? We have INCLUDE files that
> in a special directory on UNIX called /banner/sqr/inc/. /banner/sqr/inc/
> directory is neither in login PATH or ORACLE_PATH. The SQR most of the
> times find INCLUDE files in that directory okay but sometimes it can not
> find the INCLUDE files in that directory. I have no idea why it acts that
> way. I understand that we need to use "-Idir_list" or hard code the INCLUDE
> path in SQR program or put the INCLUDE path in login path to avoid the
> problem. But I am just curious to know if some one know this mysterious
> problem. Thanks.

SQR does not look at either $PATH or $ORACLE_PATH.  However, it does
look at $SQRFLAGS (and also for an SQRFLAGS setting in the SQR.INI
file).  In your case, I would guess that this variable is set for most
people/logins, but when the include files are not found it's because
SQRFLAGS is not getting set in that context.  A common example of that
is when SQR programs are run from cron jobs (or other batch systems),
because the environment for those jobs is not set up the same way
interactive jobs are set up.

If I'm correct, $SQRFLAGS contains  "-I/banner/sqr/inc/" (possibly
with other flags as well) in those environments where the programs work.

(I would strongly recommend against hardcoding the path in the SQR
programs themselves; it's a real pain to have to go in and edit them all
later!)

                                        Nathan
----------------------------------------------------------------------------
Nathan Stratton Treadway  | Ray Ontko & Co. | Software consulting services
nathant@ontko.com         | Richmond, IN    | http://www.ontko.com/