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?
NOTICE: 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.
This topic has been locked.
2 replies Latest Post - 2011-05-09T10:43:40Z by Nafeespari
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 PostsACCEPTED ANSWER
Re: Running Easy Mining Procedures from Command Window2011-05-08T21:11:43Z in response to NafeespariHi 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(?)"