Subscribe Bookmark RSS Feed

JMP - Fit Model row limit?

gerardmcl

Community Trekker

Joined:

Mar 15, 2013

Hi,

Within my script I load 338649 rows of data from an Oracle table and apply a Fit_Model (code below).

I then write the results back out to Oracle but I only get 7999 rows returned. I am missing data.

Is there a limit within JMP that is restricting the number of rows returned?

Mdl=Fit Model(

  Y( :MEAS ),

  Effects(

  :Name( "ColA" ),

  :Name( "ColB" ),

  :ColC,

  :Name( "ColD" ),

  :Name( "ColE" ),

  :ColF

  ),

  BY(:LOT,:PROD),

  Personality( Standard Least Squares ),

  Emphasis( Minimal Report ),

  Run Model(:MEAS << {Plot Actual by Predicted( 0 ),

  Plot Regression( 0 ), Plot Residual by Predicted( 0 ),

  Plot Effect Leverage( 0 )

  }

  )

);

rftmdl=Mdl<<report;

dt=rftmdl[1][Table Box(3)] << make combined datatable("Tbl_Combined");

current data table(dt);

dbc = Create Database Connection("DRIVER={Oracle in instantclient11_1};DBQ=DBQ;UID=UID;SPWD=PWD;");

for (i = 1, i <= nrows(dt), i++,

       sql_statement = .....

1 REPLY
gerardmcl

Community Trekker

Joined:

Mar 15, 2013

Turns out this is a setting on our database.

OPEN_CURSORS set to 8000 so it cuts off my INSERTS.

Now I will need to check if JMP can do the Insert a different way.

Does anyone know if JMP can do BULK INSERT?