Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 80873 invoked from network); 8 Feb 2006 14:05:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 8 Feb 2006 14:05:38 -0000 Received: (qmail 81608 invoked by uid 500); 8 Feb 2006 14:05:25 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 81581 invoked by uid 500); 8 Feb 2006 14:05:25 -0000 Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-user@db.apache.org Delivered-To: mailing list ddlutils-user@db.apache.org Received: (qmail 81570 invoked by uid 99); 8 Feb 2006 14:05:25 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Feb 2006 06:05:25 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of tomdzk@gmail.com designates 66.249.92.193 as permitted sender) Received: from [66.249.92.193] (HELO uproxy.gmail.com) (66.249.92.193) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Feb 2006 06:05:22 -0800 Received: by uproxy.gmail.com with SMTP id m3so360398ugc for ; Wed, 08 Feb 2006 06:05:01 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=K14HgQCD7AtBq7XLrnF7qxJpEEzl5nny6oidTjlkT9r3gbj9TZa8fXD/2PpAVt4IXoYiDufiOgjEXC4hbYGaiZ+0mloDgrYpA9MevfBZKGSXsMRPhjkt7QbwzRX8EvE6urHnpjZDOkBaAQ5UuAJtIyR7wq2vvAH0gFog/9fjqf4= Received: by 10.67.26.15 with SMTP id d15mr3688068ugj; Wed, 08 Feb 2006 06:05:00 -0800 (PST) Received: by 10.67.30.2 with HTTP; Wed, 8 Feb 2006 06:05:00 -0800 (PST) Message-ID: <224f32340602080605v782468e8t3672c40f0aa1fdb4@mail.gmail.com> Date: Wed, 8 Feb 2006 15:05:00 +0100 From: Thomas Dudziak To: ddlutils-user@db.apache.org Subject: Re: Database reserved words In-Reply-To: <43E9EA63.7010207@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <43E75565.80707@datasul.com.br> <43E9EA63.7010207@gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On 2/8/06, Thorbj=F8rn Ravn Andersen wrote: > I have seen databases where you could use reserved words anyway by > enclosing them in quotes when being used as table names etc. > > Does that apply to DB2 too? Yep, every database that DdlUtils supports except Axion is able to use delimited identifers. These allow to use reserved words, whitespaces etc. in table names, column names, ... You can use these in DdlUtils by setting the corresponding property in the Ant task or in the PlatformInfo instance of the platform (if using the Api). Btw, currently the delimited identifier mode is the default though this is likely to change before the 1.0. Tom