PS Query & SQL

 View Only

Did you know? -- How to query the SQL used in COBOL programs.

  • 1.  Did you know? -- How to query the SQL used in COBOL programs.

    Posted 01-22-2025 12:04 PM

    You can always query the SQL in Cobol with this SQL.  I haven't really worked with this one much.  A friend at work (Ruowei Fischer) told me about this one.

    SELECT A.PGM_NAME, A.STMT_TYPE, A.STMT_NAME, A.STMT_TEXT
      FROM PS_SQLSTMT_TBL A
      WHERE ( A.PGM_NAME = :1)



    ------------------------------
    Dana Pawlowicz
    Business Systems Analyst Sr - ERP
    University of Cincinnati
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------
    Alliance 2026 Registration is Open!