PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Can a Query write its output to a *memory* file?  (Read 485 times)

bmohrhardt

  • Silver Member
  • ***
  • Posts: 23
    • View Profile
Can a Query write its output to a *memory* file?
« 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.

Jane Raymond

  • Staff
  • Diamond Member
  • *****
  • Posts: 243
    • View Profile
    • PVX Plus Technologies
Re: Can a Query write its output to a *memory* file?
« Reply #1 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"
Jane Raymond
Software Developer
PVX Plus Technologies Ltd.

bmohrhardt

  • Silver Member
  • ***
  • Posts: 23
    • View Profile
Re: Can a Query write its output to a *memory* file?
« Reply #2 on: October 28, 2019, 12:23:04 PM »
Excellent! Thanks Jane.