RE: [sqr-users] query returns no rows for no obvious reason - it worksfine on another machine

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

Try running the query on SQL Plus to see if it's a database problem.

(You may be able to speed it up by using "union all" versus "union".  The
union command has to collect all the rows in Oracle temp space (do you have
enough?), sort them, and eliminate duplicates.  The union-all command
doesn't eliminate duplicates, so it doesn't have to buffer and sort the
results.)

-----Original Message-----
From: Jae Lee [mailto:leejc@appstate.edu] 
Sent: Wednesday, February 08, 2006 2:37 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] query returns no rows for no obvious reason - it
worksfine on another machine

hi, all,

i have a program which has quite complex query("union", etc.) that takes 
over an hour to finish.  it is SQR 8.1.  it runs and pulls data fine on 
one of our sun solaris  box, but not on the other - it returns zero 
row.  Our database is Oracle 9.  the other machine where it fails to 
return any data has 10 instances of oracle db, while the machine where 
this program works has only one instance.  Could it be timing out, b/c 
too much is going on on that box?  But it doesn't abort, ends normally - 
only it does not pull any data.  also we run the executable SQR program 
through SCT Banner 7.1 job submission on this machine with 10 
instances.  On the other machine we have Banner 6.x.  Did anybody have 
this kind of thing happen to them?  The programs and data are identical 
on two machines.  Any insight, hint, ideas are welcome..  Help!

-- jae at applachian state university, boone, nc



_______________________________________________
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