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

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

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

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

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!

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

Hi all,

I have one requirement is that ,i have create a new folde in a specified location from SQR then i want to send the report output to that folder.

To send report out put i will us new-report command ,but how to create a new folder from the SQR?
Does it possible in SQR I don't know
can any one help me on this

Thanks in advance

Ramya

Hi Guys,

I am trying to load data from an xls file using an SQR into a custom table. The read command used in my sqr is returning some garbage values instead of the correct data.
The file that has to be loaded has a header followed by rows of data....The code looks like this
let #ctr = 1
while 1=1
read 1 into $recorddata:1000
let #ctr = #ctr +1
if (#end-file = 1)
!exit
break
end-if
if isblank(rtrim(ltrim($recorddata,' '),' '))
or substr($recorddata,1,6) = 'Emplid' or substr($recorddata,1,6) = 'EMPLID'

Hi Iam working on converstion of bank file to PSBD format. I wrote a custom SQR to convert the file. But its still showing wrong format. I checked with the file layout also.

Did anybody worked on this before. If so can you please send me the SQR for this conversion process/.

I am using onbreak at two levels.The output in pdf files is proper.but when i try to put in csv files using Write command, the data gets repeated .
And if i use write command in onbreak procedures , then in the output of csv files ,the rows gets shifted .this shifting of the rows depend on data at which onbreak happens.

i am attatching the output of the csv file.

Suggest on this..