analytics/informix/extend/TSAFuncs.1.00.FC1/objects.sql

-- Generated by BladeSmith 4.20.TC1  DO NOT MODIFY. --

execute procedure ifx_allow_newline('t');

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 0, "Register UDRs",
	"%SYSBLDUSER%", 0,
	"CREATE FUNCTION Scan_RangeQuery_LPNorm (
		TimeSeries, --tsPtr
		lvarchar, --tsid
		lvarchar, --target_tscolunname
		datetime year to fraction(5), --begts
		datetime year to fraction(5), --endts
		list,  --pattern
		double precision, -- p_value
		double precision  -- dist_hb

) RETURNS list
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(scan_rangequery_lpnorm)""
       LANGUAGE c NOT VARIANT;

CREATE FUNCTION Scan_LCSS(
       		TimeSeries, --tsPtr
		lvarchar, --tsid
		lvarchar, --target_tscolunname
		datetime year to fraction(5), --begts
		datetime year to fraction(5), --endts
		list,  --pattern
		double precision,--enlarge_threshold
		double precision,--normalized delta
		double precision,--epsi
		double precision--lcss_threshold
) RETURNS list
	EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(scan_lcss)""
	LANGUAGE c NOT VARIANT;
	
CREATE FUNCTION Scan_Normal_LCSS (
       		TimeSeries, --tsPtr
		lvarchar, --tsid
		lvarchar, --target_tscolunname
		datetime year to fraction(5), --begts
		datetime year to fraction(5), --endts
		list,  --pattern
		double precision,--enlarge_threshold
		double precision,--normalized delta
		double precision,--epsilon
		double precision --normal_lcss_threshold
) RETURNS list
	EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(scan_normal_lcss)""
	LANGUAGE c NOT VARIANT;


CREATE FUNCTION Scan_DTW_NonConstraint (
       		TimeSeries, --tsPtr
		lvarchar, --tsid
		lvarchar, --target_tscolunname
		datetime year to fraction(5), --begts
		datetime year to fraction(5), --endts
		list,  --pattern
		double precision,--enlarge_threshold
		double precision --dtw_threshold
) RETURNS list
	EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(scan_dtw_nonConstraint_int_dist)""
	LANGUAGE c NOT VARIANT;	

CREATE FUNCTION Scan_DTW_Sakoe_Chiba_Constraint (
       		TimeSeries, --tsPtr
		lvarchar, --tsid
		lvarchar, --target_tscolunname
		datetime year to fraction(5), --begts
		datetime year to fraction(5), --endts
		list,  --pattern
		double precision, --enlarge_threshold
		double precision, --(normalized mConstraint_int)
		double precision  --dtw_threshold
) RETURNS list
	EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(scan_dtw_Sakoe_Chiba_Constraint_int_dist)""
	LANGUAGE c NOT VARIANT;	

	
CREATE FUNCTION Scan_DTW_Itakura_Parallelogram_Constraint (
       		TimeSeries, --tsPtr
		lvarchar, --tsid
		lvarchar, --target_tscolunname
		datetime year to fraction(5), --begts
		datetime year to fraction(5), --endts
		list,  --pattern
		double precision, --enlarge_threshold
		double precision, --(normalized mConstraint_int)
		double precision, --mCenterOffsetPercentange 
		double precision  --dtw_threshold
) RETURNS list
	EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(scan_dtw_Itakura_Parallelogram_Constraint_int_dist)""
	LANGUAGE c NOT VARIANT;
	
CREATE FUNCTION Scan_Abnormal (
       		TimeSeries, --tsPtr
		lvarchar, --tsid
		lvarchar, --target_tscolunname
		datetime year to fraction(5), --begts
		datetime year to fraction(5), --endts
		integer ,--monitorwinlen
		double precision, --abscore_threshold
		integer , --subseqLength
		integer , --stepSize
		integer , --KValue
		double precision --p_val for lp norm
) RETURNS list
	EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(scan_tsabnormal)""
	LANGUAGE c NOT VARIANT;		

CREATE FUNCTION Scan_Abnormal_Default (
       		TimeSeries, --tsPtr
		lvarchar, --tsid
		lvarchar, --target_tscolunname
		datetime year to fraction(5), --begts
		datetime year to fraction(5), --endts
		integer,  --monitorwinlen
		double precision, --abscore_threshold
		integer, --subseqLength
		--integer, --stepSize
		double precision --p_val for lp norm
) RETURNS list
	EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(scan_tsabnormal_default)""
	LANGUAGE c NOT VARIANT;			
	
	
CREATE FUNCTION Scan_RangeQuery_Pearson_Correlation (
       		TimeSeries, --tsPtr
		lvarchar, --tsid
		lvarchar, --target_tscolunname
		datetime year to fraction(5), --begts
		datetime year to fraction(5), --endts
		list,  --pattern
       		double precision --peason correlation score lower bound, ranged in [0,1]
) RETURNS list
	EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(scan_rangequery_PearsonCorrelation)""
	LANGUAGE c NOT VARIANT;
	
CREATE FUNCTION ValueAsCollection (TimeSeries, datetime year to fraction(5), datetime year to fraction(5), lvarchar)
       RETURNS list
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(getTimeseriesDataAsCollection_lvc)""
       LANGUAGE c NOT VARIANT;

CREATE FUNCTION ValueAsCollection (TimeSeries, datetime year to fraction(5), datetime year to fraction(5), integer)
       RETURNS list
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(getTimeseriesDataAsCollection_int)""
       LANGUAGE c NOT VARIANT;

CREATE FUNCTION TSgetValueList (lvarchar)
       RETURNS list
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(getvaluelist_Ptr)""
       LANGUAGE c NOT VARIANT;
	
CREATE FUNCTION TSCompute_LP_Dist (list,list,double precision)
       RETURNS double precision
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(list_compute_lp_dist)""
       LANGUAGE c NOT VARIANT;
	
CREATE FUNCTION TSCompute_LCSS_Dist (list,list,double precision, double precision)
       RETURNS integer
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(list_compute_lcss_dist)""
       LANGUAGE c NOT VARIANT;
	
CREATE FUNCTION TSCompute_Normalized_LCSS_Dist (list,list,double precision, double precision)
       RETURNS double precision
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(list_compute_normalized_lcss_dist)""
       LANGUAGE c NOT VARIANT;
	
CREATE FUNCTION TSCompute_NonConstraint_Dist (list, list )
       RETURNS double precision
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(list_compute_nonConstraint_int_dist)""
       LANGUAGE c NOT VARIANT;
	
CREATE FUNCTION TSCompute_Sakoe_Chiba_Constraint_Dist (list,list, double precision)
       RETURNS double precision
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(list_compute_Sakoe_Chiba_Constraint_int_dist)""
       LANGUAGE c NOT VARIANT;
	
CREATE FUNCTION TSCompute_Itakura_Parallelogram_Constraint_Dist (list,list, double precision,double precision)
       RETURNS double precision
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(list_compute_Itakura_Parallelogram_Constraint_int_dist)""
       LANGUAGE c NOT VARIANT;
	
CREATE FUNCTION TSSingle_Anomaly_Detection (list,integer,integer,integer, double precision)
       RETURNS list
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(single_anomaly_detection)""
       LANGUAGE c NOT VARIANT;
		
CREATE FUNCTION TSPearson_Correlation_Score (list,list)
       RETURNS double precision
       EXTERNAL NAME ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(presionCorrelationScore)""
       LANGUAGE c NOT VARIANT;
	

",
	"f",
	"DROP FUNCTION Scan_RangeQuery_LPNorm;

DROP FUNCTION Scan_LCSS;

DROP FUNCTION Scan_Normal_LCSS;

DROP FUNCTION Scan_DTW_NonConstraint;

DROP FUNCTION Scan_DTW_Sakoe_Chiba_Constraint;

DROP FUNCTION Scan_DTW_Itakura_Parallelogram_Constraint;

DROP FUNCTION Scan_Abnormal;	

DROP FUNCTION Scan_Abnormal_Default;	

DROP FUNCTION Scan_RangeQuery_Pearson_Correlation;

DROP FUNCTION ValueAsCollection (TimeSeries, datetime year to fraction(5), datetime year to fraction(5), lvarchar);

DROP FUNCTION ValueAsCollection (TimeSeries, datetime year to fraction(5), datetime year to fraction(5), integer);

DROP FUNCTION TSgetValueList (lvarchar);

DROP FUNCTION TSCompute_LP_Dist;

DROP FUNCTION TSCompute_LCSS_Dist;

DROP FUNCTION TSCompute_Normalized_LCSS_Dist;

DROP FUNCTION TSCompute_NonConstraint_Dist;

DROP FUNCTION TSCompute_Sakoe_Chiba_Constraint_Dist;

DROP FUNCTION TSCompute_Itakura_Parallelogram_Constraint_Dist;

DROP FUNCTION TSSingle_Anomaly_Detection;

DROP FUNCTION TSPearson_Correlation_Score;

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "TSAFuncsRelease ()",
	"%SYSBLDUSER%", 0,
	"create function TSAFuncsRelease ()
returns lvarchar
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(TSAFuncsRelease)"" language c;

",
	"f",
	"drop function TSAFuncsRelease ();

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-TSAFuncsRelease ()",
	"%SYSBLDUSER%", 0,
	"alter function TSAFuncsRelease ()
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(TSAFuncsRelease)"");

",
	"f",
	"alter function TSAFuncsRelease ()
	with (Modify External Name = ""TSAFuncsRelease"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-TSAFuncsRelease ()",
	"%SYSBLDUSER%",
	5, "TSAFuncsRelease ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 55, "Alter-HandleNul-TSAFuncsRelease ()",
	"%SYSBLDUSER%", 0,
	"alter function TSAFuncsRelease ()
	with (add handlesnulls);

",
	"f",
	"alter function TSAFuncsRelease ()
	with (drop handlesnulls);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	55, "Alter-HandleNul-TSAFuncsRelease ()",
	"%SYSBLDUSER%",
	5, "TSAFuncsRelease ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "TSAFuncsRelease ()",
	"%SYSBLDUSER%", 0,
	"grant execute on function TSAFuncsRelease () to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "TSAFuncsRelease ()",
	"%SYSBLDUSER%",
	5, "TSAFuncsRelease ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "TSAFuncsTraceLevel ()",
	"%SYSBLDUSER%", 0,
	"create function TSAFuncsTraceLevel ()
returns integer
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(tsaf_tracelevel_set)"" language c;

",
	"f",
	"drop function TSAFuncsTraceLevel ();

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-TSAFuncsTraceLevel ()",
	"%SYSBLDUSER%", 0,
	"alter function TSAFuncsTraceLevel ()
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(tsaf_tracelevel_set)"");

",
	"f",
	"alter function TSAFuncsTraceLevel ()
	with (Modify External Name = ""tsaf_tracelevel_set"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-TSAFuncsTraceLevel ()",
	"%SYSBLDUSER%",
	5, "TSAFuncsTraceLevel ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 55, "Alter-HandleNul-TSAFuncsTraceLevel ()",
	"%SYSBLDUSER%", 0,
	"alter function TSAFuncsTraceLevel ()
	with (add handlesnulls);

",
	"f",
	"alter function TSAFuncsTraceLevel ()
	with (drop handlesnulls);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	55, "Alter-HandleNul-TSAFuncsTraceLevel ()",
	"%SYSBLDUSER%",
	5, "TSAFuncsTraceLevel ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "TSAFuncsTraceLevel ()",
	"%SYSBLDUSER%", 0,
	"grant execute on function TSAFuncsTraceLevel () to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "TSAFuncsTraceLevel ()",
	"%SYSBLDUSER%",
	5, "TSAFuncsTraceLevel ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "TSAFuncsTraceFile ()",
	"%SYSBLDUSER%", 0,
	"create function TSAFuncsTraceFile ()
returns integer
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(tsaf_tracefile_set)"" language c;

",
	"f",
	"drop function TSAFuncsTraceFile ();

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-TSAFuncsTraceFile ()",
	"%SYSBLDUSER%", 0,
	"alter function TSAFuncsTraceFile ()
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSAFuncs.bld(tsaf_tracefile_set)"");

",
	"f",
	"alter function TSAFuncsTraceFile ()
	with (Modify External Name = ""tsaf_tracefile_set"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-TSAFuncsTraceFile ()",
	"%SYSBLDUSER%",
	5, "TSAFuncsTraceFile ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 55, "Alter-HandleNul-TSAFuncsTraceFile ()",
	"%SYSBLDUSER%", 0,
	"alter function TSAFuncsTraceFile ()
	with (add handlesnulls);

",
	"f",
	"alter function TSAFuncsTraceFile ()
	with (drop handlesnulls);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	55, "Alter-HandleNul-TSAFuncsTraceFile ()",
	"%SYSBLDUSER%",
	5, "TSAFuncsTraceFile ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "TSAFuncsTraceFile ()",
	"%SYSBLDUSER%", 0,
	"grant execute on function TSAFuncsTraceFile () to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "TSAFuncsTraceFile ()",
	"%SYSBLDUSER%",
	5, "TSAFuncsTraceFile ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 15, "ITimeSeries",
	"%SYSBLDUSER%", 0,
	"insert into sysbldirequired
	(bldi_id, bld_id)
values
(
	""ITimeSeries"",
	""%SYSBLDNAME%""
);

",
	"f",
	"delete from sysbldirequired
	where bldi_id = ""ITimeSeries""
	and bld_id = ""%SYSBLDNAME%"";

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 0, "sysbldregistered",
	"%SYSBLDUSER%", 0,
	"insert into sysbldregistered
	(bld_id)
values
(
	""%SYSBLDNAME%""
);

",
	"f",
	"delete from sysbldregistered
	where bld_id = ""%SYSBLDNAME%"";

",
	"f"
);