Search code examples
sqlpeoplesoft

Using meta tables to determine if a query is distinct

Does anyone have any idea how to use the meta-table to determine if a query is selecting a distinct value? I can't see to find anything that determines this in Meta-tables related to queries.

Appreciate all the help.

Thanks!

Solution

  • This should work:

    SELECT QRYDISTINCT FROM PSQRYSELECT WHERE QRYNAME = :1;