From user-return-526-apmail-trafodion-user-archive=trafodion.apache.org@trafodion.incubator.apache.org Wed Apr 27 04:13:46 2016 Return-Path: X-Original-To: apmail-trafodion-user-archive@minotaur.apache.org Delivered-To: apmail-trafodion-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 93F9D18FB7 for ; Wed, 27 Apr 2016 04:13:46 +0000 (UTC) Received: (qmail 78359 invoked by uid 500); 27 Apr 2016 04:13:46 -0000 Delivered-To: apmail-trafodion-user-archive@trafodion.apache.org Received: (qmail 78315 invoked by uid 500); 27 Apr 2016 04:13:46 -0000 Mailing-List: contact user-help@trafodion.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@trafodion.incubator.apache.org Delivered-To: mailing list user@trafodion.incubator.apache.org Received: (qmail 78299 invoked by uid 99); 27 Apr 2016 04:13:46 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Apr 2016 04:13:46 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 04112C0DEA for ; Wed, 27 Apr 2016 04:13:46 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.18 X-Spam-Level: * X-Spam-Status: No, score=1.18 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=esgyn.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id zcChxN0qynVq for ; Wed, 27 Apr 2016 04:13:44 +0000 (UTC) Received: from mail-wm0-f51.google.com (mail-wm0-f51.google.com [74.125.82.51]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 746455FE23 for ; Wed, 27 Apr 2016 04:13:43 +0000 (UTC) Received: by mail-wm0-f51.google.com with SMTP id u206so30835929wme.1 for ; Tue, 26 Apr 2016 21:13:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=esgyn.com; s=google; h=from:references:in-reply-to:mime-version:thread-index:date :message-id:subject:to; bh=H37GO+HKLwZXR0KydmLOb2Nr0yjtWNR4TNuAhpZ1BMs=; b=BNxDujYVbHvtImKT7vP+XzpxAHrDVqjGmgWZ+0v5YONB3kskQzq5nBSZeUBwGSfl3w B5GBbXeURu1itzjvfF0QeOVPVcm8cM7eM6urVCY+q/YqEdESY3eRmHGhvxZUPRygcrTe vvdTF3PRKG5t32krzuZW5YpP182fGNFpSFfy4= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:references:in-reply-to:mime-version :thread-index:date:message-id:subject:to; bh=H37GO+HKLwZXR0KydmLOb2Nr0yjtWNR4TNuAhpZ1BMs=; b=MvoFv6cVKNGybStiAst66cmIZI09oVPZSWzft1L74oQh11vXt95shsaEiLEYr2FoGd n0omRzkCY1s2fgukRBFTgGUQA8xEHKIRV7o1UMEl9C36qwKFQ0Wgc147A52z2woPqt4D lE5oWlr4ncH8e9habbVMEPu9JPMtB70W5q+dO04T/AKem8EjZ28raJsiE19jp83rWuu+ YEzr5jlttC7KlrVKlKaKeVsgtI6Rzqxyo+artNlRsFyk/ity+tuRrfnKmCJhE8qRqfh2 QBD8m1EwwetY3FQJh3Nk2xXOMgVVKZWRjfdYPRUVouf7lpVE1luVVKM7HQjaUu/cymqj qgyA== X-Gm-Message-State: AOPr4FUUcyS7L5b4p8avDluaDSaZPXqKK+WYvX99UOYSJJzbaR9JL/gHXd5Xd8pZII0NKd6yt2/Bzl68zN6c+w== X-Received: by 10.28.14.2 with SMTP id 2mr3927379wmo.14.1461730422430; Tue, 26 Apr 2016 21:13:42 -0700 (PDT) From: Sandhya Sundaresan References: In-Reply-To: MIME-Version: 1.0 X-Mailer: Microsoft Outlook 15.0 Thread-Index: AQKmF9vDlkhPS6ErdySe+S//r/F6mQGua85QAWxF4mad23DjsA== Date: Tue, 26 Apr 2016 21:13:37 -0700 Message-ID: Subject: RE: Create a table with BLOB or CLOB columns To: user@trafodion.incubator.apache.org Content-Type: multipart/alternative; boundary=001a1144330696333005316fa247 --001a1144330696333005316fa247 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Yes =E2=80=93 exactly. I have made most of them actually and will hold on u= ntil it=E2=80=99s 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=E2=80=99t 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? --=20 Thanks, Gunnar *If you think you can you can, if you think you can't you're right.* --=20 Thanks, Gunnar *If you think you can you can, if you think you can't you're right.* --001a1144330696333005316fa247 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Yes =E2=80=93 = exactly. I have made most of them actually and will hold on until=C2=A0 it= =E2=80=99s ready to get enabled by default.

Thanks

San= dhya

=C2=A0

From: Gun= nar Tapper [mailto:tapper.gunnar= @gmail.com]
Sent: Tuesday, April 26, 2016 9:12 PM
To:<= /b> user@trafodion.i= ncubator.apache.org
Subject: Re: Create a table with BLOB or = CLOB columns

=C2=A0

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

Gunnar

=

=C2=A0

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

<= div>

Hi Gunnar,

= =C2=A0=C2=A0 It isn=E2=80=99t turned on by default in the code yet needs mo= re testing/usage.=C2=A0 You need to set a couple of CQDs to enable. If you = create a table without setting the CQD you will get=C2=A0 large varchar col= umn instead.

=C2=A0

Take a look at the document attached =C2=A0in this JIRA for so= me details : https://issues.apache.org/jira/browse/TRAFODION-1473

=C2=A0

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

=C2=A0

Thanks

Sandhya

=C2=A0

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

=C2=A0

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

=C2=A0

--

Thanks,

=C2=A0

Gunnar

If you thin= k you can you can, if you think you can't you're right.



=C2=A0

=

--

Thanks,

<= p class=3D"MsoNormal">=C2=A0

Gunnar

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

--001a1144330696333005316fa247--