[
https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15350744#comment-15350744
]
Danoja Dias commented on DERBY-6894:
------------------------------------
SYSCS_UTIL.SYSCS_IMPORT_DATA (SCHEMANAME,TABLENAME,
INSERTCOLUMNS,COLUMNINDEXES,FILENAME, COLUMNDELIMITER
,CHARACTERDELIMITER,CODESET , REPLACE)
Here how to give values to INSERTCOLUMNS argument. I tried like follows.
CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'A', 'petName,age' ,'1,3',
'noHeaderLines.csv', null, null, null,0)
create table statement is like this.
create table A(petName varchar(50), age int)
But this gives me an Exception saying "There is no column named: petName"
I searched for an example in the Internet. But I couldn't find it. This will be
a clue to solve this 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
>
> 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)
