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,

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.1.1.0
    • 10.3.1.4
    • Tools
    • 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.txt
          6 kB
          Suresh Thalamati
        2. iexlobs_v1.txt
          11 kB
          Suresh Thalamati
        3. derby378_6.diff
          5 kB
          Suresh Thalamati
        4. derby378_5.diff
          21 kB
          Suresh Thalamati
        5. derby378_4.stat
          0.8 kB
          Suresh Thalamati
        6. derby378_4.diff
          48 kB
          Suresh Thalamati
        7. derby378_3.stat
          0.3 kB
          Suresh Thalamati
        8. derby378_3.diff
          6 kB
          Suresh Thalamati
        9. derby378_2.stat
          0.4 kB
          Suresh Thalamati
        10. derby378_2.diff
          23 kB
          Suresh Thalamati
        11. derby378_1.stat
          2 kB
          Suresh Thalamati
        12. derby378_1.diff
          132 kB
          Suresh Thalamati

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2864 LOB import unexpectedly succeeds on corrupt data

          • Major - Major loss of function.
          • Open
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2859 Misleading error message if you supply too many arguments to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2860 Documentation problems for IMPORT/EXPORT LOBs feature

          • Major - Major loss of function.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-2527 Add documentation for import/export of LOBS and other binary data types.

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: