Column Name
|
Description
|
Specification
|
---|---|---|
ModelName
|
contains the name of
the model
|
VARCHAR(128) NOT NULL
PRIMARY KEY
|
ModelDS2
|
contains the sasscore_modelname.ds2
file
|
BLOB(4M) NOT NULL
|
ModelFormats
|
contains the sasscore_modelname_ufmt.xml file
|
BLOB(4M)
|
ModelMetadata
|
Reserved by SAS for
future use
|
BLOB(4M)
|
ModelUUID1
|
contains the UUID of
the source model
|
VARCHAR (36)
|
Notes1
|
contains additional
information that describes the source model
|
VARCHAR (512)
|
1This column is for use by SAS Model Manager. If you have a model table that was created prior to SAS 9.4 and you want this column in your model table, you must run the %INDB2_CREATE_MODELTABLE macro to re-create your model table. |
%let indconn = server=yourserver user=youruserid password=yourpwd database=yourdb schema=yourschema;
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.
db2> connect to databasename user userid using password db2> select modelname from sasmodeltablename
proc sql; connect to db2 (user=userid password=xxxx database=mydatabase); select * from connection to db2 (select modelname from sas_model_table); disconnect from db2; quit;