CLPPlus and space in table name

Question

I have a new problem with CLPPlus and IMPORT command.

I try to import data into a table which contain a space in its name, but it seems to fail:

SQL> IMPORT FROM '/home/i1058/outfile' INSERT INTO USER1."TABLE 1"; 
Invalid Syntax Error
SQL> IMPORT FROM '/home/i1058/outfile' INSERT INTO USER1.'TABLE 1';
Invalid Syntax Error

I have tried many things but it always fails.

Of course I have also tried a 'classic' LOAD with CLP and it works perfectly :

db2 'LOAD FROM "outfile" OF DEL MODIFIED BY CODEPAGE=1208 NOCHARDEL INSERT INTO "USER1"."TABLE 1"'
...
Number of rows read         = 3
Number of rows skipped      = 0
Number of rows loaded       = 3
Number of rows rejected     = 0
Number of rows deleted      = 0
Number of rows committed    = 3

Any ideas ?

Thanks and regards

Answer 1

Here's how it works on my 10.5 system:

SQL> create table "TEST TBL" (f1 int);

DB250000I: The command completed successfully.

SQL> IMPORT FROM '/tmp/dat' of del insert into "TEST TBL";

Total number of rows read : 6
Total number of rows skipped : 0
Total number of rows inserted : 6
Total number of rows updated : 0
Total number of rows rejected : 0
Total number of rows committed : 6
DB250000I: The command completed successfully.
SQL> IMPORT FROM '/tmp/dat'  insert into "TEST TBL";
Invalid Syntax Error

Looks like documentation has an error in that it does not show the file type option for the CLPPlus import command.