RE: using STRSQL statement fails but works with Ops-Nav

Rob,

Nothing out of the ordinary...

strsql                                                       
Current connection is to relational database QMELDBF.        
Unable to retrieve query options file.                       
**** Starting optimizer debug message for query .            
Unable to retrieve query options file.                       
All access paths were considered for file TPDOCU.            
Additional access path reason codes were used.               
Access path of file TLDOCU47 was used by query.              
Unable to retrieve query options file.                       
All access paths were considered for file TPDOCU.            
Additional access path reason codes were used.         
File TPDOCU processed in join position 1.              
File MPPRIV processed in join position 2.              
Unable to retrieve query options file.                 
Unable to retrieve query options file.                 
Temporary result file built for query.                 
Access path built for file *N.                         
Unable to retrieve query options file.                 
Temporary result file built for query.                 
**** Ending debug message for query .                  
ODP created.                                           
Blocking used for query. 

                             

Charles


> -----Original Message-----
> From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
> Sent: Tuesday, December 23, 2003 2:15 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: using STRSQL statement fails but works with Ops-Nav
> 
> 
> If you run STRDBG prior to STRSQL and look at the joblog what 
> do you see?
> 
> Rob Berendt
> -- 
> "All creatures will make merry... under pain of death."
> -Ming the Merciless (Flash Gordon)
> _______________________________________________
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>