PxPlus User Forum

Main Board => Discussions => Programming => Topic started by: bmohrhardt on October 28, 2019, 11:43:22 AM

Title: Can a Query write its output to a *memory* file?
Post by: bmohrhardt on October 28, 2019, 11:43:22 AM
Hello Forum :

          We are starting to get some of our major files properly defined in the PxPlus Data Dictionary. In so doing, we are beginning to see how powerful and quick that defined Queries can be. Can a defined Query have its output sent to a *memory* file?  Thanks, Bill.
Title: Re: Can a Query write its output to a *memory* file?
Post by: Jane Raymond on October 28, 2019, 12:04:22 PM

Bill,
You can open a query-based file using *QUERY*. For details, see:
https://manual.pvxplus.com/page/file_handling/~query~.htm

For example:
OPEN(channel,OPT="KNO=0")"*QUERY*;MYQUERY;MYLIB"
Title: Re: Can a Query write its output to a *memory* file?
Post by: bmohrhardt on October 28, 2019, 12:23:04 PM
Excellent! Thanks Jane.