we have a datamart (UDB V9.1 fix pack 1) and one of the ETL programmers is trying to run this command "IMPORT FROM NUL OF DEL REPLACE INTO schema.table" from the data integrator tool and is getting this error:

Function call <sql ( DS_Policy_Data_Mart, IMPORT FROM NUL OF DEL REPLACE INTO KCDWHUAT.TXTAB ) > failed, due to error <70401>:
<ODBC data source error message for operation <SQLNumResultCols>: <[IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=S1010>

He says it is a DB2 problem but the command works from DB2 Control Center but not from BODI (the data integrator tool) - has anyone ever seen this before?

I suspect that you cannot really run an IMPORT command via ODBC, since it is not an SQL statement.

hmmmm that makes sense. then toad and DB2 Control Center must not be using ODBC???