[
https://issues.apache.org/jira/browse/TRAFODION-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15937744#comment-15937744
]
Sandhya Sundaresan commented on TRAFODION-2516:
-----------------------------------------------
Instead of adding support to the builtin function, added this syntax which will
be more useful for JDBC driver use.
prepare s from insert into tlob values (?);
execute s using 'fffffff';
This iwll insert a lob containing the value 'fffff'. The untypes parameter
assumes that the default input will be a string type.
insert select from a table with char/varchar columns in a table containing lob
columns. This will be useful when loading from hive tables into trafodion
tables containing LOB columns.
> Enhance stringtolob builtin function to take varchar/char columns as parameter
> ------------------------------------------------------------------------------
>
> Key: TRAFODION-2516
> URL: https://issues.apache.org/jira/browse/TRAFODION-2516
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-exe
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
>
> Today the stringtolob built in function that converts a string to a LOB type
> before inserrting into a lob column takes a string literal as input. Need to
> enhance it to take a char column or a varchar column as input too.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
