Re: Include file PATH question

[Benjamin Le <ble@PCC.EDU>]

Nathan,
You nailed this one. Thanks for pointing out "$SQRFLAGS".

At 06:52 PM 2/7/01 -0500, you wrote:
>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/


Benjamin Le
ITS, System Development
Portland Community College
12000 SW 49th Ave. Portland, Oregon 97219
Voice: (503)-977-4970   Fax: (503)-977-4987
Mailto:ble@pcc.edu      http://www.pcc.edu