Topic
  • 2 replies
  • Latest Post - ‏2011-05-09T10:43:40Z by Nafeespari
Nafeespari
Nafeespari
18 Posts

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

    Re: Running Easy Mining Procedures from Command Window

    ‏2011-05-08T21:11:43Z  
    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

    Re: Running Easy Mining Procedures from Command Window

    ‏2011-05-09T10:43:40Z  
    • M._Haide
    • ‏2011-05-08T21:11:43Z
    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(?)"
    Thanks Haide,

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

    Thanks again.

    --Nafees