Public
SELECT * FROM PSQRYDEFN WHERE OPRID <> ' '
SELECT * FROM PSQRYDEFN WHERE OPRID <> ' '
Private
SELECT * FROM PSQRYDEFN WHERE OPRID = ' '
SELECT * FROM PSQRYDEFN WHERE OPRID = ' '
How to make query to public:
Update
all below tables with OPRID=’ ’
PSQRYDEFN
- Stores high level Query Definitions with version numbers
PSQRYFIELD - Stores all Fields used in all aspects of Query operation
PSQRYRECORD - Stores all Records used in all aspects of Query operation
PSQRYSELECT - Stores all SELECT requirements by select type, i.e., union, sub select, join
PSQRYCRITERIA - Stores all Criteria Expressions in code format
PSQRYBIND - Stores run-time Prompt data
PSQRYEXPR - Stores the text associated with each Criteria Expression
PSQRYFIELD - Stores all Fields used in all aspects of Query operation
PSQRYRECORD - Stores all Records used in all aspects of Query operation
PSQRYSELECT - Stores all SELECT requirements by select type, i.e., union, sub select, join
PSQRYCRITERIA - Stores all Criteria Expressions in code format
PSQRYBIND - Stores run-time Prompt data
PSQRYEXPR - Stores the text associated with each Criteria Expression
Example:
Update PSQRYDEFN SET OPRID = ' ' WHERE QRYNAME = 'TEST' AND OPRID = ' '
Update PSQRYDEFN SET OPRID = ' ' WHERE QRYNAME = 'TEST' AND OPRID = ' '
