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

support for import/export of tables with clob/blob and the other binary data types will be good addition to derby,

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.1.0
    • Fix Version/s: 10.3.1.4
    • Component/s: Tools
    • Labels:
      None

      Description

      Currently if I have a table that contains clob/blob column, import/export operations on that table
      throghs unsupported feature exception.

      set schema iep;
      set schema iep;
      create table ntype(a int , ct CLOB(1024));
      create table ntype1(bt BLOB(1024) , a int);

      call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 'ntype' , 'extinout/ntype.dat' ,
      null, null, null) ;
      ERROR XIE0B: Column 'CT' in the table is of type CLOB, it is not supported by th
      e import/export feature.

        Attachments

        1. iexlobs_v1.txt
          11 kB
          Suresh Thalamati
        2. derby378_6.diff
          5 kB
          Suresh Thalamati
        3. derby378_5.diff
          21 kB
          Suresh Thalamati
        4. derby378_4.stat
          0.8 kB
          Suresh Thalamati
        5. derby378_4.diff
          48 kB
          Suresh Thalamati
        6. derby378_3.stat
          0.3 kB
          Suresh Thalamati
        7. derby378_3.diff
          6 kB
          Suresh Thalamati
        8. derby378_2.stat
          0.4 kB
          Suresh Thalamati
        9. derby378_2.diff
          23 kB
          Suresh Thalamati
        10. derby378_1.stat
          2 kB
          Suresh Thalamati
        11. derby378_1.diff
          132 kB
          Suresh Thalamati
        12. iexlobs.txt
          6 kB
          Suresh Thalamati

          Issue Links

            Activity

              People

              • Assignee:
                tsuresh Suresh Thalamati
                Reporter:
                tsuresh Suresh Thalamati
              • Votes:
                2 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: