[
https://issues.apache.org/jira/browse/TRAFODION-3235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16693887#comment-16693887
]
ASF GitHub Bot commented on TRAFODION-3235:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/trafodion/pull/1747
> add div and trim function for map feature, improve bad file print function.
> ----------------------------------------------------------------------------
>
> Key: TRAFODION-3235
> URL: https://issues.apache.org/jira/browse/TRAFODION-3235
> Project: Apache Trafodion
> Issue Type: New Feature
> Components: db-utility-odb
> Reporter: 苏锦佩
> Assignee: 苏锦佩
> Priority: Major
>
> In some customer scenarios, they want below feature:
> # Div function in the map file, so the numeric data in the data file can be
> divided with some value before loading to the database. for example, we have
> a COL NUMERIC(6,2) column and the data '123456' in the data file, we can use
> the mapping rule 'COL:<field>\DIV:100' to translate the data to '1234.56'
> before loading to the database.
> # Trim function in the map file, so if some field containing leading and
> trailing space in the data file can be trimmed before loading to the
> database. for example, suppose we have a COL CHAR(20) and the data ' abc
> ' in the data file, we can use the mapping rule 'COL:<field>:TRIM' to
> translate the data to 'abc' before loading to the database.
> # Now, the odb tool will print a record for each ODBC error message in the
> bad file. But some bad row may report more than one error message, so the bad
> file may contain duplicated records. So add a fix to ensure that one bad
> record only printed once in bad file.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
