Ask Question
Help Others
Home

SQR

Re:how to write data into CSV file using SQR

Fri, 09/23/2011 - 7:19am — Guest

HI guys..
AS i am new to peoplesoft ....i was asked to write data into a CSV file using SQR...i just created a CSV file but unable to write into the CSV file...can any one please help me regarding this...

Thanks ALL for ur HELP

How to send a mail to third party using sqr in windows platform

Wed, 07/20/2011 - 3:20am — Guest

I have a task that a mail has to trigger to my manager when i run a perticular SQR Program

SQR 6002 cannot open printer file C:\SPL\WOPRINT.SPF

Thu, 07/14/2011 - 6:40am — ghaniik

SQR

Any idea on the below error. This is error is generated while running a report. This usually arises when user opens a report and does not close it. This error usually occurs for citrix users. I have tried renaming the file WOPRINT.spf but it says it’s in use and cannot rename.

SQR 6002 cannot open printer file C:\SPL\WOPRINT.SPF

Please advice.

Regards,

SQR NEW-REPORT and the internal page counter reset

Mon, 03/21/2011 - 5:31pm — Guest

I have an SQR program that produces 2 reports, which I would like to use NEW-REPORT to dynamically name the output. The output is generated for each report simultaneously, meaning I have to write to each report with each record in the query. I don't write one report, finish it, then write the second.

I've read elsewhere that NEW-REPORT will reset the internal page counter on the reports when executed. I think this is why my output is only giving me one record, as opposed to my sample of 3.

How would I customize my SQR to have a .csv output instead of PRINT-DIRECT ?

Wed, 08/04/2010 - 8:23am — ksreekanth2010

Hi,

Could anyone suggest/help me how would I customize my SQR program to have a .csv output.
Right now the sqr using PRINT-DIRECT command and is sending output directly to .lis
The original output (Result) can be obtained,in this case, only after print
I need it ASAP please!!

Thanks in advance!!

Sree

running AE from SQR

Tue, 08/03/2010 - 1:55am — anithan

Hi,
how to run AE program from sqr
thanks in advance

SQR-Heading Section

Mon, 08/02/2010 - 6:15am — anithan

Hi,
In heading-section is it madatary to specify the no.of lines for heading?
i.e is Begin-heading 6
.If not madatary how many lines the system will allocate defaulty
thanks in advance

SQR data types

Thu, 07/29/2010 - 12:28am — anithan

Hi,
In sqr variable String and Date are preceded with $ only.
So how the system will recognize weather it's type of date or string .
thanks in advance

Where to set SQRFLAGS in Unix?

Sat, 06/05/2010 - 9:31pm — Gavin

We are in the midst of upgrading from 8.8 to 9.1 HCM. We setup a Tools 8.5 Development database. When I run a SQR from a Unix script, I get a "Cannot find #include file SETENV.SQC" error. I know I need to set the -i flag to specify the custom and delivered SQR directories, but am not sure where? Rather than the SQR command line, isn't there a file like PSSQR.UNX that I can add some code to that will tell the system what the flags are? Please let me know where and what the syntax is.

Thanks in advance for your help!

when Printing a paragraph with different lines in PDF format using a sqr, a box appear at each line break.

Mon, 11/23/2009 - 9:51am — Guest

Hi, I am trying to print a paragraph taken from message catalog using a SQR and generate the report in pdf format. the value selected is having many lines like bulleted. but when it gets printed, the lines are not comming in seperate line, instead they come continously seperated by a box. while I generate the report in .lis format, it is coming in line by line. Pls let me know, how to remove the box and get the output as line by line