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 Improvement
    • Status: Closed
    • Priority: Major 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.

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

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development