db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dmclea...@comcast.net
Subject RE: Question relating Bulk import
Date Wed, 17 Jan 2007 14:07:15 GMT
That's an interesting quote. Where did you find it?

I have tried to document common problems on:

http://wiki.apache.org/db-derby/DerbySQLroutines

(at the end, Section 6: Common Problems)

Donald

 -------------- Original message ----------------------
From: "Chitale, Sachin" <sachin.chitale@credit-suisse.com>
> My fault ... I read and forgot to apply:
> 
> If you create a schema, table, or column name as a non-delimited identifier, you 
> must
> pass the name to the import procedure using all upper-case characters. If you 
> created a
> schema, table, or column name as a delimited identifier, you must pass the name 
> to the
> import procedure using the same case that was used when it was created. 
> 
> Thanks Peter
> 
> -----Original Message-----
> From: Chitale, Sachin 
> Sent: 17 January 2007 18:50
> To: 'derby-user@db.apache.org'
> Subject: Question relating Bulk import
> 
> 
> Hi,
> 
> I am trying to import rows using:
> 
> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('auser','some_tbl', '/tmp/bcp/some_tbl', 
> NULL,'', NULL,0);
> 
> Which results in:
> ERROR XIE0M: Table 'auser.some_tbl' does not exist.
> 
> If from the same ij instance I run 
> ij> select count(*) from auser.some_tbl;
> 1
> -----------
> 0
> 
> Can someone explain the 1st error if the second query goes through.

Mime
View raw message