Re: PeopleSoft/Sqr/Unix/Process Sceduler [.]

[Franck Masson <franck.masson@BRIO.COM>]

hi,

to cover an execution of sqr  and print the output on unix
you can do

sqr report.sqr -printer:hp
lp -dprinter report.lis

In this shell script we suppose:
1)printer type is HP that mean it is compatible PCL
2)the report will generate one output with the name of the sqr file
3)the printer name is printer

In peoplesoft you can modify the process scheduler process types windows
parameters for your sqr report and change the command line parameter
by replacing the sqr executable with a shell that will execute the
report and print the output
it is easy for a guy that know unix and shell
this shell will have this organisation
/sqrpath/sqr $$         /execute as befor sqr with the same parameter
extract from parameter list the output of the sqr execution
(-f option of sqr flag ) and put this in SQROUPUT variable
(ask to a unix guy to help to extract this value from the list of
parameters)
cd $SQROUTPUT
lp -dprinter *.lis


the only thing i miss in this scenario is the way to get the name of the
printer.
if the printer name is allway the same, it is easy.
if you can retreive the printer name using the parameters value of the
job (like operid ) it is ok.
in the other case ask support from your peoplesoft guy.

I am not a Peoplesoft specialist.


Hope this help you

franck,
Rick_Creel@AONCONS.COM wrote:
>
> Perhaps you could embed a "call system" type command that would print the 
>report
> when the SQR has completed.
>
> Another option would be to have your Unix Administrator write a shell script
> that would run via a cron job and it would look for report files to print, 
>print
> them, and then rename the file so that you still have it for archive purposes,
> but it wouldn't be reprinted when the cron job recycles.
>
> Philip Latone <platone@MCC.MIRACOSTA.CC.CA.US> on 05/18/2000 12:30:18 PM
>
> Please respond to sqr-users@list.iex.net
>
> To:   SQR-USERS@list.iex.net
> cc:    (bcc: Rick Creel/IT/Aon Consulting)
>
> Subject:  PeopleSoft/Sqr/Unix/Process Sceduler [.]
>
> When I try to run a Cross Reference Window Listing (or any other SQR
> Report) on the server and a printer output destination of lj925, the report
> ends up in $PS_HOME/bin under the name lj925.
>
> Question: How do you print a server side SQR from unix using Process
> Scheduler without logging in to unix and issuing a lp command?
>
> HPUX 11.0
> Oracle 8.0.6
> PSFT SA 7.6
> Ptools 7.58
>
> Here is a list of valid Unix printers:
> #lpstat -t
> scheduler is running
> system default destination: lj925
> device for lj925: /dev/null
> device for lj970: /dev/null
> device for lj950: /dev/null
> device for lj900: /dev/null
> device for ljlrc: /dev/null
>
> Config File:
> #cat psprcs.cfg
> [Startup]
> ;=========================================================================
> ; Database Signon settings
> ;=========================================================================
> DBName=HEDEV
> DBType=ORACLE
> OprId=PRCS
> OprPswd=
> ConnectId=
> ConnectPswd=
> ServerName=
>
> [Database Options]
> ;=========================================================================
> ; Database-specific configuration options
> ;=========================================================================
> ; Please see Chapter "Tuning and Administration", in
> ; Sybase Installation and Administration Guide for details.
> SybasePacketSize=512
> ; Please see Chapter "Tuning and Administration", in
> ; Oracle Installation and Administration Guide for details
> UseLocalOracleDB=0
>
> [Trace]
> ;=========================================================================
> ; SQL Trace flags
> ;=========================================================================
>
> ;-------------------------------------------------------------------------
> ; SQL Tracing Bitfield
> ;
> ; Bit       Type of tracing
> ; ---       ---------------
> ; 1         - SQL statements
> ; 2         - SQL statement variables
> ; 4         - SQL connect, disconnect, commit and rollback
> ; 8         - Row Fetch (indicates that it occurred, not data)
> ; 16        - All other API calls except ssb
> ; 32        - Set Select Buffers (identifies the attributes of columns
> ;             to be selected).
> ; 64        - Database API specific calls
> ; 128       - COBOL statement timings
> ; 256       - Sybase Bind information
> ; 512       - Sybase Fetch information
> TraceSQL=0
>
> [Process Scheduler]
> ;=========================================================================
> ; General settings for the Process Scheduler
> ;=========================================================================
> LogFence=0
> ProgramName=PSRUN_HEDEV PTPUPRCS
> PrcsServerName=PSUNX
> PSSQR1=%PS_HOME%/sqr
> PSSQR2=
> PSSQR3=
> PSSQR4=
> PSSQRFLAGS=-i%PSSQR1%/,%PSSQR2%/,%PSSQR3%/,%PSSQR4%/
> -m%PSSQR1%/allmaxes.max -ZI
> F%PSSQR1%/pssqr.unx
> Log Directory=%PS_SERVDIR%/logs
> OutputDirectory=%PS_SERVDIR%/output/
>
> pshe@iceman : /home/pshe/he758/appserv/prcs/HEDEV
> #
>
>   ------------------------------------------------------------------------
>
>                            Name: PSPT_PSUNX.stdout
>    PSPT_PSUNX.stdout       Type: unspecified type (application/octet-stream)
>                        Encoding: base64
begin:          vcard
fn:             Franck Masson
n:              ;Franck Masson
org:            Brio Technology EMEA
adr;dom:        Le capitol;;55 av. des champs Pierreux;Nanterre;92000;;
email;internet: franck.masson@brio.com
title:          Sales Manager Northern Europe
tel;work:       33 1 55 69 36 00
tel;fax:        33 1 47 25 02 59
tel;home:       Mobile : 33 6 84 80 17 05
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard