Look at the SampleSQL.txt file that is produced when
the %INDTD_PUBLISH_MODEL macro is successfully run. This file can
be found in the output directory (OUTDIR argument) that you specify
in the macro.
The SampleSQL.txt file
contains basic SQL code that can be used to run your score code inside
Teradata. Please note that you must modify the sample code before
using it. Otherwise, the sample code returns an error.
For example, this SampleSQL.txt
file refers to an ID column in allmush1_intab
that
is populated with a unique integer from 1 to n. n is
the number of rows in the table. The ID column uniquely identifies
each row. You would replace the ID column with your own primary key
column.
The following example
assumes that the model name that you used to create the scoring functions
is allmush1
.
drop table allmush1_outtab;
create table allmush1_outtab(
id integer
,"EM_CLASSIFICATION" varchar(33)
,"EM_EVENTPROBABILITY" float
,"EM_PROBABILITY" float
);
insert into allmush1_outtab(
id
,"EM_CLASSIFICATION"
,"EM_EVENTPROBABILITY"
,"EM_PROBABILITY"
)
select id,
allmush1_em_classification("BRUISES"
,"CAPCOLOR"
,"GILLCOLO"
,"GILLSIZE"
,"HABITAT"
,"ODOR"
,"POPULAT"
,"RINGNUMB"
,"RINGTYPE"
,"SPOREPC"
,"STALKCBR"
,"STALKROO"
,"STALKSAR"
,"STALKSHA"
,"VEILCOLO")
as "EM_CLASSIFICATION",
allmush1_em_eventprobability("BRUISES"
,"CAPCOLOR"
,"GILLCOLO"
,"GILLSIZE"
,"HABITAT"
,"ODOR"
,"POPULAT"
,"RINGNUMB"
,"RINGTYPE"
,"SPOREPC"
,"STALKCBR"
,"STALKROO"
,"STALKSAR"
,"STALKSHA"
,"VEILCOLO")
as "EM_EVENTPROBABILITY",
allmush1_em_probability("BRUISES"
,"CAPCOLOR"
,"GILLCOLO"
,"GILLSIZE"
,"HABITAT"
,"ODOR"
,"POPULAT"
,"RINGNUMB"
,"RINGTYPE"
,"SPOREPC"
,"STALKCBR"
,"STALKROO"
,"STALKSAR"
,"STALKSHA"
,"VEILCOLO")
as "EM_PROBABILITY"
from allmush1_intab ;