Re: Selecting Specific Member in MSQuery

Simon,

Having never writen a stored procedure from within MS Query I am not sure if it 
will work but I will give it a try just to see.  

By placing it into the SQL I would have to edit the statement each day I want 
to run it which is harder that what I do today but may spark another idea.

Thanks,
John

>>> "Simon Coulter" <shc@flybynight.com.au> 02/17 7:14 PM >>>
First the Caveat:  I don't use MS products at all.

CALL QCMDEXC ("OVRDBF FILE(PERFDATA) TOFILE(PERFDATA) TOMBR(CURRENT)", 
X'000000005200000F')
SELECT * FROM PERFDATA

Or is the real problem that MS Query won't let you control the SQL statements 
so you don't get a chance to 
run the override?

Regards,
Simon Coulter.

                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                     
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---