I m novice to db2.

Import from 'c:\temp\devtest.del' of del insert into devtestone(col1,col2)

gives the error as:

15:13:51 [IMPORT - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=Import from 'c:\temp\devtest.del' of del;BEGIN-OF-STATEMENT;<space>, DRIVER=3.57.82
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]


Please advice,
Thanks,

What DB2 version and OS are you using? How are you trying to execute the import statement?

Andy

publish some rows of data from the infile
and the layout of the table

IMPORT is not an SQL statement; it is a CLP command and must be run from the CLP. If you insist on using the SQL interface, consider ADMIN_CMD(): IMPORT using ADMIN_CMD - IBM DB2 9.7 for Linux, UNIX, and Windows

thank you for the response.

Now I m executing:
CALL SYSPROC.ADMIN_CMD ('Import from c:/temp/devtest.del of del insert into devtestone(col1,col2)')

I get error as:

15:07:49 [CALL - 0 row(s), 0.000 secs] [Error Code: -3030, SQL State: ] DB2 SQL Error: SQLCODE=-3030, SQLSTATE= , SQLERRMC=sqlofopn -2029060079, DRIVER=3.57.82
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]


I m using db2 9.7
and table lay out is

col1 (decimal) col2(VARCHAR)
========== ===
1 testone
2 testtwo

i tried this in an another method by using "ADOX.Catalog" object .. i got he result