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?
Pinned topic Running Easy Mining Procedures from Command Window
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-05-09T10:43:40Z at 2011-05-09T10:43:40Z by Nafeespari
M._Haide 060000132W6 Posts
Re: Running Easy Mining Procedures from Command Window2011-05-08T21:11:43ZThis is the accepted answer. This is the accepted answer.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 270003YJJ018 Posts