Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6467

Document context-aware table functions.

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.11.1.1
    • Fix Version/s: 10.11.1.1
    • Component/s: Documentation
    • Labels:
      None

      Description

      Now that we have added AwareVTI and VTIContext to the public api, it would be good to document how to use them. Perhaps we could add a "Writing a context-aware table function" subtopic under the "Programming Derby-style table functions" topic in the Developer's Guide.

      As an example, the new subsection could use ArchiveVTI together with the script which is part of the 2014-02-02 comment on DERBY-6117.

      Context-aware table functions are useful when you need to describe a family of results which have the following properties:

      1) Each result in the family has a shape which is determined by a different table.

      2) There may be several results associated with a given table. In addition to having the same shape, the sub-family of results differ from one another based on some variables which cannot be represented as ? parameters in a SELECT statement.

        Attachments

        1. DERBY-6467-2.zip
          6 kB
          Camilla Haase
        2. DERBY-6467-2.stat
          0.1 kB
          Camilla Haase
        3. DERBY-6467-2.diff
          16 kB
          Camilla Haase
        4. cdevspecialtfcontext.html
          7 kB
          Camilla Haase
        5. DERBY-6467.stat
          0.1 kB
          Camilla Haase
        6. DERBY-6467.diff
          6 kB
          Camilla Haase

          Issue Links

            Activity

              People

              • Assignee:
                chaase3 Camilla Haase
                Reporter:
                rhillegas Richard N. Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: