Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-987

Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Obsolete
    • Major
    • Future
    • 7.4
    • Editors, Transformations
    • None

    Description

      Designer includes "Generate xxxx procedures" options in the New Model Wizard.

      Also have a RestEasy use-case that requires getXXXX virtual procedures that contain SQL like:

      CREATE VIRTUAL PROCEDURE
      BEGIN
      SELECT XMLELEMENT(NAME parts, XMLAGG(XMLELEMENT(NAME part, XMLFOREST(VirtualParts_Supplier.PARTS.PART_ID, VirtualParts_Supplier.PARTS.PART_NAME, VirtualParts_Supplier.PARTS.PART_COLOR, VirtualParts_Supplier.PARTS.PART_WEIGHT)))) AS result FROM VirtualParts_Supplier.PARTS WHERE VirtualParts_Supplier.getParts.partId_in = VirtualParts_Supplier.PARTS.PART_ID;
      END

      Would be nice to have a framework where "wizards" can be accessed to create/edit the content of this SQL if the basic structure is a Set Query (SELECT * FROM XXX)for these specific use-cases.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              blafond Barry LaFond
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: