db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chitale, Sachin" <sachin.chit...@credit-suisse.com>
Subject RE: Question relating Bulk import
Date Wed, 17 Jan 2007 13:41:31 GMT
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.

Thanks
Sachin

==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:


http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================


Mime
View raw message