Re: [sqr-users] SQR not executing sql statements

[Al H <star111lists@mindspring.com>]

In addition to the other suggestions here, add a -s parameter to your
command line.  This will tell SQR to log the actual SQL statements and
show their number of executions.  If you are running from within
PeopleSoft, you can set the parameter on teh SQR Parms portion of the
Process Scheduler page where you can Append to the command line.

On Sat, 17 May 2003 13:33:59 -0400, you wrote:

>I am hoping that someone can help. I created a new sqr program that is to be 
>run from a page in PeopleSoft. I believe that I have set everything up 
>correctly because I am able to run the SQR from within PeopleSoft and it 
>runs to success.
>
>However, the SQR is not executing any of the sql. I know that the sqr is 
>running as it will execute any show statements - however, I am trying to 
>select from a table and it the program doesn't seem to be executing the sql
>
>sql statement -->
>
>show 'before select'
>begin-select
>a.emplid
>       let $emplid = &a.emplid
>       show 'emplid: '$emplid
>       from sysadm.ps_job a
>where a.emplid = value
>and a.action = value
>and a.action_reason = value
>and a.effdt = value
>end-select
>
>show 'after select'
>
>---
>The log file will show the two before and after show statements, but not the 
>one within the sql and I know that there is data to be selected as I can run 
>the sql in Oracle directly and get the correct results.
>I am not sure if the problem is with the setup of the new page or with the 
>actual sqr. I don't think it's the setup of the objects because I can access 
>the run control and can run the program.
>
>This is running on an NT server, oracle database.
>
>Any suggestions would be helpful.
>Thanks!
>
>_________________________________________________________________
>Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
>http://join.msn.com/?page=features/featuredemail
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users