You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by "Chitale, Sachin" <sa...@credit-suisse.com> on 2007/01/17 11:50:21 UTC

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
==============================================================================


Re: Question relating Bulk import

Posted by Peter Ondruska <pe...@gmail.com>.
Try:

CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('AUSER','SOME_TBL',
'/tmp/bcp/some_tbl', NULL,'', NULL,0);

On 1/17/07, Chitale, Sachin <sa...@credit-suisse.com> wrote:
>
> 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
> ==============================================================================
>
>