From ddlutils-user-return-715-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org Thu Oct 04 08:31:14 2007 Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 65532 invoked from network); 4 Oct 2007 08:31:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Oct 2007 08:31:13 -0000 Received: (qmail 51272 invoked by uid 500); 4 Oct 2007 08:31:02 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 51256 invoked by uid 500); 4 Oct 2007 08:31:02 -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 51245 invoked by uid 99); 4 Oct 2007 08:31:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Oct 2007 01:31:02 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of allanjunli@gmail.com designates 64.233.182.188 as permitted sender) Received: from [64.233.182.188] (HELO nf-out-0910.google.com) (64.233.182.188) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Oct 2007 08:31:03 +0000 Received: by nf-out-0910.google.com with SMTP id d3so69225nfc for ; Thu, 04 Oct 2007 01:30:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; bh=BiNvuhE2A8OmbQfvIyKi7uXZIfATLq3a2iR81/ynhOE=; b=PibIuQaweu7YXY+vGA2y659aP7hiQb8Zk9S/SQQV8beKPKqjhnwrvpEKzH/gfTQLVWSl2I3vyWifDslqqHW+mlfq9oQelnMsrpsPzza+LUcgWHIFLi6leZgRSlctkzT/YvwoeL+Z5cAuS/egyP6zB6AUQRfjmY6sagGALpEpNNo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=fAtDjgIvxaXDxu4M/M+CbdYkfbouMm2qEFmMqnQ8i7QinxGqus9YaF88VUZUCWDaRp/fQ09leFgIGxSGhLckqxt8OnqQPk35X1G3G8v3tpRyy2KwwyX3JZzUBT4gGoeQWBhs6QpcqbpdM/GcoK49HIW1iptKLHtlJGqmJ93ni5A= Received: by 10.78.107.8 with SMTP id f8mr7441812huc.1191486633962; Thu, 04 Oct 2007 01:30:33 -0700 (PDT) Received: by 10.78.167.5 with HTTP; Thu, 4 Oct 2007 01:30:33 -0700 (PDT) Message-ID: Date: Thu, 4 Oct 2007 18:30:33 +1000 From: "Jun Li" To: ddlutils-user@db.apache.org Subject: Re: DDL Utils... In-Reply-To: <13033491.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_25082_27239478.1191486633954" References: <13033491.post@talk.nabble.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_25082_27239478.1191486633954 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I think you have to define the default value in that case. Otherwise, you will lost your data. On 10/4/07, callme_sanjay wrote: > > > Hello Team, > > when the table already has data how is the utility taking > care of updating existing columns from NULL to NOT NULL... > > Please reply > On Behalf of Satyam B. > > -- > View this message in context: > http://www.nabble.com/DDL-Utils...-tf4566113.html#a13033491 > Sent from the Apache DdlUtils - User mailing list archive at Nabble.com. > > -- ------------ Cheers, Jun ------=_Part_25082_27239478.1191486633954--