Re: Creating multiple reports on mainframe

[Steve Rogers <srogers@KBTOYS.COM>]

Cindy,

     Thank you very much for responding.  I would just like to clarify a few
things-

     -When you mention the member of your parmlib, are you referring to -
          - the Config Manager SQR flag settings in PeopleSoft
          - the SQRPARMS member, which in our environment looks like this -

          DSN SYSTEM(DHP2)
          RUN PROG(SQR)  -
          PLAN(DBCALLS) -
          LIB('SYS3.PSOFT.SQR.LOAD') -
          PARMS('DDN:SQRIN DSN/PSOFTPRD -FDDN:SQROUT -P:HP -S -
                -IDDN:SQRINC( -TBZ -MDDN:MAXIN')
          END

          - something else?

     - We typically run our SQR's from PeopleSoft using shell JCL, which
defaults the print file to a DDNAME of SYSOUT.       We do have a few SQR's that
we don't run from PeopleSoft.  They are run on the mainframe as stand alone
jobs.  If        we need to use "custom" DDNAMES for the multiple reports, then
I assume I will have to create a new stand         alone job, with it's own JCL.
I don't see how I could do this using the shell JCL.  Is this what you had in
mind, or am I       missing something?

     Thanks again for your help.  This is the first time we have attempted this.
It could be quite helpful now and in the           future.

     Steve





Cindy Chen <sxc4@POP.CWRU.EDU> on 10/03/2001 11:02:50 AM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Steve Rogers/North/KayBee)

Subject:  Re: Creating multiple reports on mainframe



Hi Steve,

      You need :
1. in the member of your parmlib, make sure you have flags:
        -FRPT1 -FRPT2 ....
2. then in your JCL, you will need to have ddname RPT1 and RPT2 which point
to a pre-allocated PDS, ex.,
      //RPT1 dd dsn=your.pds(myrpt1)...
      //RPT2 dd dsn=your.pds(myrpt2)...

HTH

Cindy
At 08:42 AM 10/3/2001 -0400, you wrote:
>      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