Re: SQR default "-i" modification question

[Jeff Linsley <LinsleyJ@NATFUEL.COM>]

Could you post the syntax to include the -i flag in the ini file?
I have been trying to find documentation and it is no where to be found.  At least I can't find it.

Jeff 
>>> "White, Denise" <DWHITE@SYSTEMS.TEXTRON.COM> 11/12/99 09:56AM >>>
I am surprised to see several people advising against this, as it is the
standard practice with the PeopleSoft system (as someone else said,
apologies to the non-PS users on the list).  As a matter of fact, four
directories are usually the standard.  The usual order is: 1) a development
directory on your C: drive (ex. c:\user\sqr\), 2) a 'production' library on
the C: drive (c:\psoft\sqr\) - we actually have never used this, but my
understanding is that it would be used if you have a user who for some
reason always needs to run a different version of the production program
than others do, 3) a user directory on the network drive
(n:\psoft\ver\user\sqr\), where you would store all your in-house-developed
production programs as well as any modified PSoft programs, and 4) the
vanilla PSoft SQR directory on the network (n:\psoft\ver\sqr\).  I am
mentioning 'programs', but this applies equally to the SQR programs
themselves and the SQCs.  This way, the system will pick up modified code
from 3) while leaving the vanilla code intact and in place in 4).  While you
are doing development, your jobs will pick up 1) while everyone else is
still running production from 3) or 4).  We have been using this system for
over five years, and it has not caused us any maintenance problems.  It is
easy to see all the in-house and modified programs just by looking in 3),
without having to use special naming conventions (not that there's anything
wrong with that!) or copying the vanilla code somewhere else.

One problem that can be caused in Configuration Manager is that including
all these directories may push you over the character limit of PSSQRFLAGS.
We kicked around a number of solutions, none of which were very
satisfactory, until someone from PSoft advised me to put the -i flag in
PSSQR.INI.  As long as you are using the -zif flag to point to PSSQR.INI
(which you should, for Y2K date format compliance), this flag will be
included.  It has worked out very well for us.

Well that's my 2 cents worth!
Denise White
Sr. IT Application Developer
Textron Systems
> ------------------------------
>
> Date:    Thu, 11 Nov 1999 09:23:19 CST
> From:    the dragon <ceprn@HOTMAIL.COM>
> Subject: Re: SQR default "-i" modification question
>
> Dave,
>
> I agree with you that it is not a good choice to set up the directory
> structure this way if that is what they are planning on doing in a
> prodcution environment; however, if they are using a migratory path that
> lets them put modified programs in directory X/Y, where they have write
> permissions, for testing, and then once they pass testing, to migrate them
> to directory X, where they do not have write permissions, and then
> removing
> them from X/Y, this makes solid sense.  That way other developers, if the
> company doesn't have a solid software control system in place, always know
> where the most current version of the code resides, as well as gives them
> a
> place to look to see if someone else is modifying the program.
>
> Additionally, it does make sense to have a naming standard that allows
> easy
> identification of internal vs delivered software; however, if you change
> PS
> programs, it's best to leave them named what they are, as other
> programs/processes may call them by that name.  As always, if you change
> delivered code, such as POPO005.sqr, remember to keep a copy of the
> original
> in a safe place - it makes updating your code during upgrades 900% easier.
>
> clark 'the dragon' willis
> dragon enterprises, consulting services
>
>
> ----Original Message Follows----
>
> Dennis,
>          Why not keep your SQC's in the PeopleSoft delivered location and
> prefix your SQC with a standard recognizable series of characters that
> make
> them stand out from PeopleSoft SQC's ?  You will be potentially creating
> yourself a maintenance problem by maintaining two directories.
>
> -----Original Message-----
>
>
>   I want to modify the default report flags setting for the "-i" parameter
> from pointing to just one directory as it does now to point to 2
> directories.  I would like to change it for both SQRW.EXE and for
> PeopleSoft.  I know that the string is in the Configuration
>   Manager/Process Scheduler tab and I can change it there, but where is
> the
> default kept ?  I would like the SQR processes to look for "#includes" in
> 2
> directories.
>
>   I want to change it from "J:\hrms\hr750\sqr\"  to
> "J:\hrms\hr750\sqr\;J:\hrms\hr750\user\sqr"
>   (hard to see but there is a semi-colon there)  so that we can keep our
> home grown "sqc"s separate from those delivered by PeopleSoft yet still
> make
> them accessible to everyone without a lot hassle.   My environment is:
>
>            PeopleSoft 7.5.1
>            SQR 4.3.2
>            NT file server
>            Oracle 8.0.4
>            Windows 95 on the workstations
>
>   Any help would be appreciated.  Thank you.