Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007

    Unanswered: Cannot run import command

    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?

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    I suspect that you cannot really run an IMPORT command via ODBC, since it is not an SQL statement.
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Dec 2007
    hmmmm that makes sense. then toad and DB2 Control Center must not be using ODBC???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts