specifies the name of the tablespace that resides in the primary partition.
Tip | You can get the name of the tablespace from your database administrator. |
specifies the name of a DB2 database where the sasscore_modelname.ds2 and sasscore_modelname_ufmt.xml scoring files are held.
Default | The database specified in the INDCONN macro variable or your current database |
specifies the name of the table that holds the sasscore_modelname.ds2 and sasscore_modelname_ufmt.xml scoring files.
Default | sas_model_table |
Requirements | The maximum table name length is 128 characters and it must be a valid DB2 table name. |
The table name that you specify for this macro must be the same table name that is used in the %INDB2_PUBLISH_MODEL macro. | |
See | %INDB2_PUBLISH_MODEL Macro Syntax |
specifies one of the following actions that the macro performs:
creates a new table.
Tip | If the table has been previously defined and you specify ACTION=CREATE, an error is issued. |
overwrites the current table, if a table with the same name is already registered.
Tip | If you specify ACTION = REPLACE, and the current table contains sasscore_modelname.ds2 and sasscore_modelname_ufmt.xml files, the files are deleted and an empty table is re-created. |
causes all models in this table to be dropped.
Default | CREATE |
proc sql; connect to db2 (user=userid password=xxxx database=mydatabase); create table work.sas_score_out1 as select * from connection to db2 (WITH T1 as (SELECT * from SCORE_INPUT_TABLE where X1 < 1.0) SELECT * from T1 ANALYZE_TABLE (IMPLEMENTATION 'PROVIDER=SAS; ROUTINE_SOURCE_TABLE=myschema.SAS_PUBLISH_MODEL; ROUTINE_SOURCE_NAME="Intr_Tree";') ); disconnect from db2; quit;
specifies the input table that is used by the ANALYZE_TABLE function.
specifies the name of the schema where the scoring model files are published.
specifies the name of the model table where the sasscore_modelname.ds2 and sasscore_modelname_ufmt.xml scoring files were published with the %INDB2_CREATE_MODELTABLE macro.
Requirement | The table name that you specify for this function must be the same table name that is used in the %INDB2_CREATE_MODELTABLE macro. For more information, see %INDB2_CREATE_MODELTABLE Macro Syntax. |
specifies the name of the model.