Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4555 Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines
  3. DERBY-6894

Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 10.13.1.0
    • SQL
    • None

    Description

      To ease maintainability and legibility of client programs, it would be
      nice if callers of SYSCS_IMPORT_DATA_BULK (and possibly also
      SYSCS_IMPORT_DATA) could refer to columns in the COLUMNINDEXES
      argument by column NAME, as well as by index NUMBER.

      So, for example, a valid COLUMNINDEXES specification might be:

      '1,3,LastName,FirstName,7'

      Attachments

        1. Derby-6894.diff
          2 kB
          Danoja Dias
        2. repro.java
          2 kB
          Danoja Dias
        3. noHeaderLines.csv
          0.0 kB
          Danoja Dias
        4. repro.java
          2 kB
          Danoja Dias
        5. petlist.csv
          0.1 kB
          Danoja Dias
        6. NewDerby6894.diff
          4 kB
          Danoja Dias
        7. NewDerby6894_2.diff
          12 kB
          Danoja Dias
        8. NewDerby6894_3.diff
          30 kB
          Danoja Dias
        9. readHeadersLoadError.diff
          28 kB
          Bryan Pendleton
        10. EndofLineError.diff
          29 kB
          Danoja Dias

        Issue Links

          is depended upon by

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-6870 Google Summer of Code 2016: Derby bug fixing

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Dnj Danoja Dias
              bryanpendleton Bryan Pendleton
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: