Can a Query write its output to a *memory* file?

Started by bmohrhardt, October 28, 2019, 11:43:22 AM

Previous topic - Next topic

bmohrhardt

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.

Jane Raymond


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"
Jane Raymond
Software Developer
PVX Plus Technologies Ltd.

bmohrhardt