Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Bangalore
    Posts
    21

    Unanswered: XML View of Relational Data

    My requirement is
    (1) Ability to create user defined XML views over relational tables
    (2) Views should not be materialized ones.

    The application will operate on these XML views using XQuery etc. (though the data would be in relational columns as primitive data types).

    Is this possible using pureXML feture in DB2 V9.1 for Linux Unix & Windows

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Yes this is possible
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Feb 2004
    Location
    Bangalore
    Posts
    21
    Is there any built infunction which provides XML view of relational data. Can you guide me to any documentation to achieve this.

  4. #4
    Join Date
    Jun 2006
    Posts
    471

    xml

    to create a view, a regular sql select has to be defined
    see xml guide for many samples to select data from tables with xml
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •