nested table type

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sumitv13
    New Member
    • Nov 2012
    • 4
    #1

    nested table type

    Hello,
    In DB2,we can't use nested table type and after discussion we split type into 2 type and now we r using by this way we are getting so many problems.and one by one we are trying to solve.

    Why DB2 is not supporting nested type ,,
    now i get this site for discussion ..so i am asking my all the problems with respect to DB2
    PLEASE HELP ME OUT..........
    Tags: None
    • zmbd
      Recognized Expert Moderator Expert
      • Mar 2012
      • 5501
      #2
      Why DB2 is not supporting nested type ,,
      now i get this site for discussion ..so i am asking my all the problems with
      Not to be mean... and with all respect... the answer is: "Because that's the way they designed it."

      I think you might have a really good question in there somewhere so, please take a second pass at the question... think about what you want as a goal... post/describe what you've already done and someone here might beable to help you with a workaround etc...

        Comment

        • Rabbit
          Recognized Expert MVP
          • Jan 2007
          • 12517
          #3
          Most databases don't supported nested table types. Nested tables can just as easily be expressed as a related table.

            Comment

            • zmbd
              Recognized Expert Moderator Expert
              • Mar 2012
              • 5501
              #4
              Rabbit,
              So true... it's a feature in the Oracle databases that I found to be true <insert> when we lost a DB for one of the instrument drivers... pain to rebuild and recover.

                Comment

                • sumitv13
                  New Member
                  • Nov 2012
                  • 4
                  #5
                  Thanks for reply ..

                  I faced one biggest problem with this nested type is,if i am having type with 90+ col and
                  this type is coming from front end and we are doing some operation by this type like
                  (insert into table or selecting etc. )on that time my DB2 server is stopped.
                  but if we make one standalone function in front end and from there they will call BE package.then it works.
                  but if we use in our application and try to call BE package so DB2 server is stopped(shutdow n).
                  and after 7-8time DB2 server creshed and again we did all the things..we discussed with IBM support and type gave jar for that problem
                  because the problem related to jar if we do not use jcc4 jar so it do not give any problem.and they updated some thing into jar and
                  gave to us.
                  now we are doing development. i thing this is best site to share or get some thing (DB2...).i googled and i get this site.

                  thanks alot..........:-)

                    Comment

                    Previous template Next
                    Working...