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: '[email protected]' 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 ==============================================================================
