Thank you Knut and Rick very much it now works a treat. Cheers Glenn
> Date: Tue, 12 Jan 2010 10:20:33 +0100 > From: [email protected] > Subject: Re: Importing > To: [email protected] > > Glenn Ambrose <[email protected]> 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 _________________________________________________________________ Time for a new car? Sell your old one fast! http://clk.atdmt.com/NMN/go/157637060/direct/01/
