Peoplesoft SQR

Cannot open the #include file 'setenv.sqc

I'm running the SQR through PeopleSoft scheduler and i'm getting the following error.
cannot open the #include file '\\serverName\path\setenv.sqc'
No such file or directory
SQR for peoplesoft: Program aborting.
I have updated the SQR report output destination from PeopleSoft Process definition to \\ServerName\Path so that it would generate the output PDF on this path. When I am running the sqr program through process scheduler it going to success and generating the output PDF file on above mentioned (\\ServerName\Path) path.

sqr max number of print lines

SQR does not print more than 78 rows with standard peopltools sqc of ptpsp125.sqc with small font

How do I get an SQR to print 78 rows using the standard sqc. How do I do it without using the sqc. I am using a standard HP PCL.

Essentially, number of max lines should depend on font size. smaller font size (I am using size 8) should allow for more max lines and I think the default for the sqc is size 10. There should be another sqc that sets the font size and max lines accordingly. for font size 8.

Mansoor H. Khan
Principle Programmer at Thales Defense & Security, Inc.

How to search a sting in SQR

Hi ,
How to i search a string in the sqr? Is there any command used to search ?

Execute stored procedure from SQR

I have a stored procedure that must do insert on link server, I have the following code that execute the stored procedure:

Begin-SQL On-Error=SQL-Error
EXECUTE SP_JDEEmployee $Emplid $Name $JDE-Julian
End-SQL

I get the following error on executing the SQR

SQL Status = 16954, SQL Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Executing SQL directly; no cursor.

Can you retrieve Text from PeopleSoft Text Catalog using an SQR

is it possible to retrieve the Text From the PeoopleSoft Text Catalog using PeopleSoft SQR? I saw a different posting identifying that you could use the Strings table, but I want to know if you can retrieve the text from the Text Catalog using an SQR.

SQR from Process Schuduler

Any One Help Me With An Example Program. How Can I Run SQR Program Through Process Scheduler.

Reading data from .CSV File using SQR

Hi All,
I have the below requiremnet to add DESCRLONG column to the Input File(CSV) to load data from SQR to Job code Table,but there could be special character (Comma) ‘,’ in the DESCRLONG Column, So when I am trying to read data from CSV,it is treating ‘,’ (comma) in DESCR LONG Column as delimiter and remaining part after the Comma is getting assigned to the Next column.

I tried many ways to read the DESCRLONG column as single but unable to fix the Issue.

ANY BODY CAN HELP

IN RUNCONTROL PAGE THER IS BUSINESS UNIT GRID IS THER ...VALUES ARE AA,BB,CC,DD,EE
FOR THAT MY REQUIRMENT IS I WANT A REPORT AS 'AA','BB','CC','DD','EE'
FROM DIS CODE
BEGIN-PROCEDURE Init-Report

LET $STR1 = ''

DO Select-Parameters

END-PROCEDURE

BEGIN-PROCEDURE Select-Parameters

BEGIN-SELECT
RC3.BUSINESS_UNIT &BUSINESS_UNIT
LET $BUSINESS_UNIT = &BUSINESS_UNIT
LET $STR1 = $STR1 || ''' ||$BUSINESS_UNIT|| '','

FROM PS_PES_MAC_SAT_BU RC3
WHERE RC3.OPRID = $prcs_oprid
AND RC3.RUN_CNTL_ID = $prcs_run_cntl_id
END-SELECT

Folder Compare

I am comparing two folders. One is demo and the other one is custom. I have taken the common files in both the folder and put it in an array.
Now I need to get a list of modified files in the custom folder by calling cmd prompt command. Which command will be easier to get the solution?

Sample outbound sqr

Hi,

Does any one have sqr to write the data into a file with batch, header, detail info
010 batch
020 header
030 detailed

Thanks in Advance