Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 87142 invoked from network); 18 Jul 2006 19:18:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 18 Jul 2006 19:18:14 -0000 Received: (qmail 64560 invoked by uid 500); 18 Jul 2006 19:18:14 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 64529 invoked by uid 500); 18 Jul 2006 19:18:13 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 64518 invoked by uid 99); 18 Jul 2006 19:18:13 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Jul 2006 12:18:13 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Jul 2006 12:18:13 -0700 Received: from ajax.apache.org (localhost [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id 5F784D498B for ; Tue, 18 Jul 2006 20:17:52 +0100 (BST) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: derby-commits@db.apache.org Date: Tue, 18 Jul 2006 19:17:52 -0000 Message-ID: <20060718191752.18046.69710@ajax.apache.org> Subject: [Db-derby Wiki] Update of "DerbySQLroutines" by DonaldMcLean X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Dear Wiki user, You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification. The following page has been changed by DonaldMcLean: http://wiki.apache.org/db-derby/DerbySQLroutines ------------------------------------------------------------------------------ Up until at least 10.1.3, attempting to call a procedure with the wrong number of parameters causes an SQL exception: "ERROR 42Y03: 'SYSCS_UTIL.SYSCS_IMPORT_DATA' is not recognized as a function or procedure.". + === SYSCS_IMPORT_DATA + + The last line of data must be terminated with an end-of-line (possibly system dependant) or you will get an exception: "ERROR 38000: The exception 'SQL Exception: Read endOfFile at unexpected place on line 3.' was thrown while evaluating an expression." + + The table and field names must be given in ALL UPPER CASE. Otherwise you will get "ERROR XIE0M: Table 'property' does not exist." or "ERROR XIE08: There is no column named: set_id." +