trafodion-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sandhya Sundaresan <sandhya.sundare...@esgyn.com>
Subject RE: Create a table with BLOB or CLOB columns
Date Wed, 27 Apr 2016 05:00:56 GMT
Most likely looks like Trafodion 2.1.

Thanks

Sandhya



*From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
*Sent:* Tuesday, April 26, 2016 9:27 PM
*To:* user@trafodion.incubator.apache.org
*Subject:* Re: Create a table with BLOB or CLOB columns



When is this planned? I'm asking since there are a couple of chapters in
the upcoming JDBC T4 Guide that discuss LOB support.



On Tue, Apr 26, 2016 at 10:13 PM, Sandhya Sundaresan <
sandhya.sundaresan@esgyn.com> wrote:

Yes – exactly. I have made most of them actually and will hold on until
it’s ready to get enabled by default.

Thanks

Sandhya



*From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
*Sent:* Tuesday, April 26, 2016 9:12 PM
*To:* user@trafodion.incubator.apache.org
*Subject:* Re: Create a table with BLOB or CLOB columns



Thanks Sandhya. I assume that the how-to is part of the upcoming changes to
the SQL Reference Manual for BLOB/CLOB support?

Gunnar



On Tue, Apr 26, 2016 at 10:04 PM, Sandhya Sundaresan <
sandhya.sundaresan@esgyn.com> wrote:

Hi Gunnar,

   It isn’t turned on by default in the code yet needs more testing/usage.
You need to set a couple of CQDs to enable. If you create a table without
setting the CQD you will get  large varchar column instead.



Take a look at the document attached  in this JIRA for some details :
https://issues.apache.org/jira/browse/TRAFODION-1473



And for simple examples on how to turn on the CQD and create , insert,and
extract take a look at core/sql/regress/executor/TEST130 for several
examples.



Thanks

Sandhya



*From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
*Sent:* Tuesday, April 26, 2016 8:58 PM
*To:* user@trafodion.incubator.apache.org
*Subject:* Create a table with BLOB or CLOB columns



How do I create a table with BLOB or CLOB columns?



-- 

Thanks,



Gunnar

*If you think you can you can, if you think you can't you're right.*





-- 

Thanks,



Gunnar

*If you think you can you can, if you think you can't you're right.*





-- 

Thanks,



Gunnar

*If you think you can you can, if you think you can't you're right.*

Mime
View raw message