Re: PeopleSoft/Sqr/Unix/Process Sceduler

["Bowman, Rick" <Rick.Bowman@MARRIOTT.COM>]

The Unix SA needs to setup printques for the printers that you want to print
to.  Then you will need to select printer in the Process Scheduler, and put
/tmp/+p-dprintername.

Thanks,
Rick Bowman

301.380.9112

> -----Original Message-----
> From: Philip Latone [SMTP:platone@MCC.MIRACOSTA.CC.CA.US]
> Sent: Thursday, May 18, 2000 12:30 PM
> To:   SQR-USERS@list.iex.net
> 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
> #
>
>  << File: PSPT_PSUNX.stdout >>  << File: ATT389658.txt >>