analytics/informix/extend/spatial.8.22.FC2/objects_supp.sql

-- Generated by BladeSmith 3.60.TC2  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, "stream.sql",
	"%SYSBLDUSER%", 0,
	"create function streamwrite(stream, ST_Point) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_Point) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_PointStreamRead)'
  language c;

create function streamwrite(stream, ST_MultiPoint) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_MultiPoint) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_MPointStreamRead)'
  language c;

create function streamwrite(stream, ST_LineString) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_LineString) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_LineStreamRead)'
  language c;

create function streamwrite(stream, ST_MultiLineString) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_MultiLineString) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_MLineStreamRead)'
  language c;

create function streamwrite(stream, ST_Polygon) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_Polygon) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_PolyStreamRead)'
  language c;

create function streamwrite(stream, ST_MultiPolygon) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_MultiPolygon) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_MPolyStreamRead)'
  language c;

create function streamwrite(stream, ST_Curve) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_Curve) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_CurveStreamRead)'
  language c;

create function streamwrite(stream, ST_MultiCurve) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_MultiCurve) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_MCurveStreamRead)'
  language c;

create function streamwrite(stream, ST_Surface) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_Surface) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_SurfaceStreamRead)'
  language c;

create function streamwrite(stream, ST_MultiSurface) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_MultiSurface) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_MSurfaceStreamRead)'
  language c;


create function streamwrite(stream, ST_GeomCollection) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_GeomCollection) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_GeomCollStreamRead)'
  language c;

create function streamwrite(stream, ST_Geometry) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(GeometryStreamWrite)'
  language c;

create function streamread(stream, OUT ST_Geometry) returns integer
  with (not variant, parallelizable)
  external name '$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_GeomStreamRead)'
  language c;

grant execute on function streamwrite(stream,ST_Point) to public;
grant execute on function streamread(stream,ST_Point) to public;
grant execute on function streamwrite(stream,ST_MultiPoint) to public;
grant execute on function streamread(stream,ST_MultiPoint) to public;
grant execute on function streamwrite(stream,ST_LineString) to public;
grant execute on function streamread(stream,ST_LineString) to public;
grant execute on function streamwrite(stream,ST_MultiLineString) to public;
grant execute on function streamread(stream,ST_MultiLineString) to public;
grant execute on function streamwrite(stream,ST_Polygon) to public;
grant execute on function streamread(stream,ST_Polygon) to public;
grant execute on function streamwrite(stream,ST_MultiPolygon) to public;
grant execute on function streamread(stream,ST_MultiPolygon) to public;
grant execute on function streamwrite(stream,ST_Curve) to public;
grant execute on function streamread(stream,ST_Curve) to public;
grant execute on function streamwrite(stream,ST_MultiCurve) to public;
grant execute on function streamread(stream,ST_MultiCurve) to public;
grant execute on function streamwrite(stream,ST_Surface) to public;
grant execute on function streamread(stream,ST_Surface) to public;
grant execute on function streamwrite(stream,ST_MultiSurface) to public;
grant execute on function streamread(stream,ST_MultiSurface) to public;
grant execute on function streamwrite(stream,ST_GeomCollection) to public;
grant execute on function streamread(stream,ST_GeomCollection) to public;
grant execute on function streamwrite(stream,ST_Geometry) to public;
grant execute on function streamread(stream,ST_Geometry) to public;

",
	"f",
	"
drop function streamwrite(stream,ST_Point);
drop function streamread(stream,ST_Point);
drop function streamwrite(stream,ST_MultiPoint);
drop function streamread(stream,ST_MultiPoint);
drop function streamwrite(stream,ST_LineString);
drop function streamread(stream,ST_LineString);
drop function streamwrite(stream,ST_MultiLineString);
drop function streamread(stream,ST_MultiLineString);
drop function streamwrite(stream,ST_Polygon);
drop function streamread(stream,ST_Polygon);
drop function streamwrite(stream,ST_MultiPolygon);
drop function streamread(stream,ST_MultiPolygon);
drop function streamwrite(stream,ST_Curve);
drop function streamread(stream,ST_Curve);
drop function streamwrite(stream,ST_MultiCurve);
drop function streamread(stream,ST_MultiCurve);
drop function streamwrite(stream,ST_Surface);
drop function streamread(stream,ST_Surface);
drop function streamwrite(stream,ST_MultiSurface);
drop function streamread(stream,ST_MultiSurface);
drop function streamwrite(stream,ST_GeomCollection);
drop function streamread(stream,ST_GeomCollection);
drop function streamwrite(stream,ST_Geometry);
drop function streamread(stream,ST_Geometry);

",
	"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, "SE_SuppRelease ()",
	"%SYSBLDUSER%", 0,
	"create function SE_SuppRelease ()
returns lvarchar
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/spatial_supp.bld(SE_SuppRelease)""
language c;

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

",
	"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%", 69, "SE_SuppRelease ()",
	"%SYSBLDUSER%", 0,
	"grant execute on function SE_SuppRelease () 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, "SE_SuppRelease ()",
	"%SYSBLDUSER%",
	5, "SE_SuppRelease ()",
	"%SYSBLDUSER%"
);