I'm running the SQR through PeopleSoft scheduler and i'm getting the following error.
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 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.
Hi ,
How to i search a string in the sqr? Is there any command used to search ?
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.
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.
Any One Help Me With An Example Program. How Can I Run SQR Program Through Process Scheduler.
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.
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
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?
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
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 16 weeks ago
2 years 21 weeks ago
2 years 21 weeks ago
2 years 23 weeks ago
2 years 23 weeks ago
2 years 24 weeks ago
2 years 26 weeks ago
2 years 27 weeks ago
2 years 30 weeks ago
2 years 36 weeks ago