Thank you Knut and Rick very much it now works a treat.

Cheers
Glenn

> Date: Tue, 12 Jan 2010 10:20:33 +0100
> From: Knut.Hatlen@Sun.COM
> Subject: Re: Importing
> To: derby-user@db.apache.org
>
> Glenn Ambrose <glennambrose@hotmail.com> writes:
>
> > This is what happens when you don't subscribe first.
> >
> > Replying to Rick (thanks for the response)
> >
> > Hi Glenn,
> >
> > It doesn't look to me like you are putting single quotes around the file
> > name when you construct the statement which calls SYSCS_IMPORT_TABLE.
> > The file name is a string argument to the procedure and so needs to be
> > single-quoted.
> >
> > Hope this helps,
> > -Rick
> >
> > I added single quotes to the file name
> >
> > carrier.execute(
> > "CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE (null,'elements'," +
> > "'" + dataSource + "'" + ",null,null,null,0)"
> > );
> >
> > Now I get a different error message
> >
> > Exception in thread "main" java.sql.SQLException: Table 'ROOT.elements' does
> > not exist.
>
> Try 'ELEMENTS' instead of 'elements'. Derby converts unquoted
> identifiers to upper case internally, and the arguments to
> SYSCS_IMPORT_TABLE must exactly match the canonical form of the
> identifier.
>
> --
> Knut Anders


Sell your old one fast! Time for a new car?