You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@trafodion.apache.org by Gunnar Tapper <ta...@gmail.com> on 2016/04/27 05:57:46 UTC
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.*
Re: Create a table with BLOB or CLOB columns
Posted by Gunnar Tapper <ta...@gmail.com>.
Thanks!
On Tue, Apr 26, 2016 at 11:00 PM, Sandhya Sundaresan <
sandhya.sundaresan@esgyn.com> wrote:
> 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.*
>
--
Thanks,
Gunnar
*If you think you can you can, if you think you can't you're right.*
RE: Create a table with BLOB or CLOB columns
Posted by Sandhya Sundaresan <sa...@esgyn.com>.
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.*
Re: Create a table with BLOB or CLOB columns
Posted by Gunnar Tapper <ta...@gmail.com>.
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.*
RE: Create a table with BLOB or CLOB columns
Posted by Sandhya Sundaresan <sa...@esgyn.com>.
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.*
Re: Create a table with BLOB or CLOB columns
Posted by Gunnar Tapper <ta...@gmail.com>.
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.*
RE: Create a table with BLOB or CLOB columns
Posted by Sandhya Sundaresan <sa...@esgyn.com>.
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.*