Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

LPTR clause

Directs query output to a printer.


LPTR [n]


The LPTR clause directs all output from a query statement to printer channel 0. The same operation can be performed using the (P letter code option. LPTR n directs all output from a query statement to the printer channel specified in n. For further information on printer channels, refer to the “Spooler Commands” chapter of The Caché MultiValue Spooler.

In Caché MultiValue (and all emulations except Reality, jBase, and UniData) issuing a CMQL statement with an LPTR clause closes the spooler job when the CMQL program terminates. In UniData emulation, a CMQL statement gets its own unique spooler job. This default behavior can be changed using SP-CONDUCT.