Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
Message-ID: <4134DFB0.2060708@Source-Zone.org>
Date: Tue, 31 Aug 2004 13:29:36 -0700
From: Suresh Thalamati <tsuresh@Source-Zone.org>
Reply-To: tsuresh@Source-Zone.org
User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)
MIME-Version: 1.0
To: derby-user@db.apache.org
Subject: RE:Derby, DB2, & Syntax (Jeff Ramsdale) 
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

 > Date: Fri, 27 Aug 2004 13:45:19 -0700 (PDT)
 > From: Jeff Ramsdale <jefe182@yahoo.com>
 > Subject: Derby, DB2, & Syntax
 > Content-Type: text/plain; charset=us-ascii

 > Hi all,
 >
 > I've got an application that uses a DB2 database I'd
 > like to swap out with Derby for testing purposes. I
 > understand from
 > 
http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0408cline/
 > that Cloudscape was made to be (mostly?) syntax
 > compatible with DB2 and wanted to verify that's the
 > case with Derby.
 >
 > My DB2 test database is populated by a set of SQL
 > scripts as well as a set of IXF files. Previously I
 > tried converting the scripts to HSQLDB's SQL syntax
 > and using that tool for testing, but the syntax was
 > different enough to cause trouble. In addition I
 > couldn't find a way to read the DB2 IXF files in
 > without writing a custom import tool.
 >
 > So, I'm checking out Derby hoping it'll fit the bill
 > where HSQLDB didn't. Several questions, then...
 > 1) Is there a tool for loading data into Derby from
 > IXF files?
 >

Data from files in IXF format can not be exported into Derby.  Derby 
currently supports loading from
Delimited file format (DEL).  If you can export data from DB2 using DB2 
export utility in  DEL format,
you will be able to load into derby using import system procedures.

Following link has some information about Derby import/export system 
procedures:
http://incubator.apache.org/derby/manuals/tools/tools89.html#HDRSII-IMPORT-12925

-suresh