Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 12063 invoked from network); 8 Feb 2010 11:19:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 8 Feb 2010 11:19:54 -0000 Received: (qmail 36303 invoked by uid 500); 8 Feb 2010 11:19:53 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 36225 invoked by uid 500); 8 Feb 2010 11:19:53 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 36217 invoked by uid 99); 8 Feb 2010 11:19:53 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Feb 2010 11:19:53 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of glennambrose@hotmail.com designates 65.55.90.207 as permitted sender) Received: from [65.55.90.207] (HELO snt0-omc4-s4.snt0.hotmail.com) (65.55.90.207) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Feb 2010 11:19:43 +0000 Received: from SNT107-W36 ([65.55.90.199]) by snt0-omc4-s4.snt0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Mon, 8 Feb 2010 03:19:22 -0800 Message-ID: Content-Type: multipart/alternative; boundary="_d1d9aa55-4bad-4e43-bb2e-e3e0220291db_" X-Originating-IP: [115.64.119.4] From: Glenn Ambrose To: Derby Java DB Subject: import with column Date: Mon, 8 Feb 2010 11:19:21 +0000 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 08 Feb 2010 11:19:22.0061 (UTC) FILETIME=[903567D0:01CAA8B0] X-Virus-Checked: Checked by ClamAV on apache.org --_d1d9aa55-4bad-4e43-bb2e-e3e0220291db_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Does 'CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(...)=3B' handle column names? I've= noticed that when the database that we use 'Agrobase' exports to .csv it a= lways adds the column names to the top of the row. What's the best way of handling this as I can't see any any provisions for = this in the above procedure. Thanks Glenn =20 _________________________________________________________________ Search for properties that match your lifestyle! Start searching NOW! http://clk.atdmt.com/NMN/go/157631292/direct/01/= --_d1d9aa55-4bad-4e43-bb2e-e3e0220291db_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi

Does 'CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(...)=3B' handle column n= ames? I've noticed that when the database that we use 'Agrobase' exports to= .csv it always adds the column names to the top of the row.

What's = the best way of handling this as I can't see any any provisions for this in= the above procedure.

Thanks
Glenn

Sta= rt searching NOW! Search for properties that match your lifestyle! = --_d1d9aa55-4bad-4e43-bb2e-e3e0220291db_--