[
https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15369210#comment-15369210
]
Danoja Dias commented on DERBY-6894:
------------------------------------
Hi Bryan,
{quote}
if 'skip > 0', open the input file, read the first
'skip' number of lines, parse the column structure, and construct an array of
the column headers, then close the input file and return the headers array
{quote}
Yes, this is the exact thing this patch does.
In ImportReadData.java file,
openFile() , closeStream() functions are called several times.
Whenever the ImportReadData.java class is used, opening file and closing file
happens several times. Therefore would it be a issue?
> Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns
> by name
> -------------------------------------------------------------------------------------
>
> Key: DERBY-6894
> URL: https://issues.apache.org/jira/browse/DERBY-6894
> Project: Derby
> Issue Type: Sub-task
> Components: SQL
> Reporter: Bryan Pendleton
> Assignee: Danoja Dias
> Priority: Minor
> Attachments: Derby-6894.diff, NewDerby6894.diff, noHeaderLines.csv,
> petlist.csv, repro.java, repro.java
>
>
> 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'
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
