Re: sqr supplied tools

[Nathan Treadway <nathant@ONTKO.COM>]

On Thu, Nov 12, 1998 at 09:45:41AM -0600, DarnielleC wrote:
> Thanks that worked great.  This now makes be question why this file wasn't
> created during the installation routine.  I took a look at the language
> reference and found a chapter on the sqr.ini,  I think I can determine what
> settings I need from there.

I haven't used this version of SQR or PeopleSoft yet, but I think this is
what's happening:
  * PeopleSoft  distributed pssqr.ini instead of sqr.ini.  (Perhaps
    they did this so that the settings there wouldn't affect the default
    settings for non-PeopleSoft SQR work at sites that do that.)
  * The SQR command was set to use -ZIF to point to the pssqr.in file, so
    it doesn't need sqr.ini.
  * The viewer, whether called by -ZIV or manually, doesn't have the -ZIF
    flag passed to it, so it is still looking for sqr.ini.

So, you could either copy pssqr.ini to sqr.ini, or you can just create a
"minimal" sqr.ini for use by the Viewer (as Steve suggested).

I am guessing that, in addition to the "SQRDIR=dummy" line you mention
below, you have another SQRDIR line in your pssqr.ini (in a
[Environment:<database>] section) that does point to the proper directory.
(Is this true?)  I'm fairly sure that SQRW won't run without at least
it's error message file, which is found in the SQRDIR directory.

The Viewer may run without its error message file.  However, if there is an
error it won't be able to give you the error message.  For this reason, you
might want to edit the [Environment: Common] section of sqr.ini (assuming
that that's the INI file the Viewer is using) to set SQRDIR to point to the
proper directory.  Editing the line in pssqr.ini didn't have any effect
because the view wasn't looking in that file and SQR was looking in the
DB-specific section.

Hope this helps (and that it is still true in your version of SQR and in
your environment).


> > -----Original Message-----
> > From: Steve Schelske [SMTP:skschelske@WORLDNET.ATT.NET]
> > Sent: Thursday, November 12, 1998 9:20 AM
[...]
> > You have to have a SQR.INI file!  It is not the same as the PSSQR.INI
> > file,
> > you need both.
> >
[...]
> > -----Original Message-----
> >
> > Subject: Re: sqr supplied tools
> >
> >
> > I was trying to show you an example of a failure situation.  The -ZIV
> > flag allows me to have the report generated automatically passed to the
> > viewing program.  Of course, at this time instead of sqrv.exe program
> > launching, it errors out.  The -ZIF flag is set on my command line and
> > is pointing to p:\HR750\sqr\pssqr.ini.  Currently, the section in this
> > file is set to.
> >
> > [Environment:Common]
> > SQRDIR=dummy
> >
> > Obviously this looks wrong, but I have tried setting it to the correct
> > path of my SQR executables and have had no effect, even rebooted my
> > workstation. I have also tried doing a set command in my autoexec.bat
> > file.  It's really strange because I would have thought one of the above
> > would have corrected the issue.
> >
> > Not that I think it should matter but, as most people have implied there
> > is an sqr.ini file.  My installation doesn't have this file anywhere, I
> > assume that the file pssqr.ini is it with a different name.  Also this
> > file is running off a network drive, there shouldn't be a problem with
> > this should there?  Do I need this file locally?

This should be in the directory where the SQRWV.EXE file is.  (See Chapter 8
of the SQR v4 manual for more info on where SQR looks for the file.)

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