Several programmers/users have asked me to forward this question ree: SQL Window operation: (we use PSD 7)
PSD 6 let you select the "Export Query Results...." before you even F8. That way you could direct the results to be saved, then press F8, and then go on home.
PSD 7 doesn't even show that selection until a screen-full of results is returned and for some of our queries that could be a lot of minutes or even hours. The causes the person to stay here until a first rows appear and then do the Export selection.
I've showed them how to do this with SPOOL statment in a Command Window but that's a lot more effort.
How can we do a function closer to the PSD 6 method?
Thanks.
PSD 6 let you select the "Export Query Results...." before you even F8. That way you could direct the results to be saved, then press F8, and then go on home.
PSD 7 doesn't even show that selection until a screen-full of results is returned and for some of our queries that could be a lot of minutes or even hours. The causes the person to stay here until a first rows appear and then do the Export selection.
I've showed them how to do this with SPOOL statment in a Command Window but that's a lot more effort.
How can we do a function closer to the PSD 6 method?
Thanks.
