Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    42

    Unanswered: stored proc on typed tables

    db ESE
    i have typed tables. i will create a stored procedure where i will store all the data from the 2 subtype tables in one table. for example, if i have supertype person with subtypes employee and student. in the new table that i will create, all the data will be included regardless of their type and having nulls to those fields that are not appropriate for each.
    sample
    personID name type studentID empNo
    1 abc S 123 <blank>
    2 def E <blank> 456

  2. #2
    Join Date
    Feb 2007
    Posts
    42
    how can i perform union of those two tables?

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Typed tables already provide that functionality. So what exactly are you asking here?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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