Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2011-05-09T10:43:40Z by Nafeespari
Nafeespari
Nafeespari
18 Posts
ACCEPTED ANSWER

Pinned topic Running Easy Mining Procedures from Command Window

‏2011-05-07T16:53:40Z |
Hi,

I want to run the mining procedures from the command window. I tried to run the following statement but am getting this error:

db2 "Call IdMMX.BuildClasModel('Administrator.nursery_model','administrator.nursery','class')"

but I am getting this error:

SQL4302N Procedure or user-defined function "IDMMX.BUILDCLASMODEL", specific
name "SQL110419204720803" aborted with an exception "IDM9080E: The table/view
with ". SQLSTATE=38M01

Any tip on that?

--Nafees
Updated on 2011-05-09T10:43:40Z at 2011-05-09T10:43:40Z by Nafeespari
  • M._Haide
    M._Haide
    6 Posts
    ACCEPTED ANSWER

    Re: Running Easy Mining Procedures from Command Window

    ‏2011-05-08T21:11:43Z  in response to Nafeespari
    Hi Nafees,
    according to the error IDM9080E the table or view: administrator.nursery
    does not exist. Please check if the table is available exactly in the way you have specified it. The parameter is case sensitive, no automatic uppercase conversion is done!

    A problem when working from command line is that you often does not see the full message because the message buffer provided for Stored Procedures is very small. To get the full error message you could call:

    db2 "call idmmx.getlasterror(?)"
    • Nafeespari
      Nafeespari
      18 Posts
      ACCEPTED ANSWER

      Re: Running Easy Mining Procedures from Command Window

      ‏2011-05-09T10:43:40Z  in response to M._Haide
      Thanks Haide,

      I did not use the correct case. My problem is solved.

      Thanks again.

      --Nafees