[jira] [Commented] (TRAFODION-2516) Enhance stringtolob builtin function to take varchar/char columns as parameter

["Sandhya Sundaresan (JIRA)" <ji...@apache.org>]

    [ 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)