Re: Creating multiple reports on mainframe

[Ed Mahoney <Ed_Mahoney@PROVIDENTCOMPANIES.COM>]

I'm not sure if this applies to V4.1.7.3, but it does seem to apply to V6.1.4
delivered with PeopleSoft 8.13. You will need to have the SQROUT directed to a
file instead of SYSOUT=. The name of the SPF file is built from the SQROUT file
name and it can't use SYSOUT= to build the SPF file name.

Ed Mahoney
UnumProvident Corporation
Chattanooga Office - 3S
(423) 755-1572


|--------+------------------------>
|        |          Steve Rogers  |
|        |          <srogers@KBTOY|
|        |          S.COM>        |
|        |          Sent by:      |
|        |          "Discussion of|
|        |          SQR, Brio     |
|        |          Technology's  |
|        |          database      |
|        |          reporting     |
|        |          language"     |
|        |          <SQR-USERS@lis|
|        |          t.iex.net>    |
|        |                        |
|        |                        |
|        |          10/03/2001    |
|        |          08:42 AM      |
|        |          Please respond|
|        |          to sqr-users  |
|        |                        |
|--------+------------------------>
  >----------------------------------------------------------------------------|
  |                                                                            |
  |       To:     SQR-USERS@list.iex.net                                       |
  |       cc:                                                                  |
  |       Subject:     Creating multiple reports on mainframe                  |
  >----------------------------------------------------------------------------|




     Good morning all -

     We are running PeopleSoft DB2 for MVS, version 7.51.  All of our SQR's are
processed using the mainframe as our server.  I am attempting to create two
different reports from the same SQR.  I used the DECLARE-REPORT options
according to the SQR server Language Reference.  When I attempt to run the SQR,
I am receiving the following error -

(SQR 6002) Cannot open the printer file: DDN:SQROUT.SPF
(13): Improper function argument

     It appears as if the the SQROUT DD name is automatically receiving the .SPF
suffix, which MVS can't seem to process.

     Does anyone know how to resolve this problem?

     thanks,
     Steve