You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Sandhya Sundaresan (JIRA)" <ji...@apache.org> on 2018/02/01 18:30:00 UTC
[jira] [Commented] (TRAFODION-2742) Linux and Windows ODBC need to
support LOB
[ https://issues.apache.org/jira/browse/TRAFODION-2742?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16349060#comment-16349060 ]
Sandhya Sundaresan commented on TRAFODION-2742:
-----------------------------------------------
This work will require some design in the ODBC layer as well as SQL support.
[https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlputdata-function]
Need to investigate the following to implement sqlputdata :
# Solution 1 : Try to implement input streaming, just like JDBC, in ODBC by translating the sqlputdata to an “update “ statement with append.
# Solution 2 : Define APIs to allow dummy lob handle creation for ODBC driver to be able to use for binding and sending BLOB data . Allow insert into a lob base table to take in a lobHandle string directly in the row in varchar format. This would help us implement the full ODBC standard .
> Linux and Windows ODBC need to support LOB
> --------------------------------------------
>
> Key: TRAFODION-2742
> URL: https://issues.apache.org/jira/browse/TRAFODION-2742
> Project: Apache Trafodion
> Issue Type: Technical task
> Components: client-jdbc-t4, connectivity-mxosrvr, sql-exe
> Reporter: Weiqing Xu
> Assignee: Weiqing Xu
> Priority: Major
> Fix For: 2.3
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)