{ DATABASE dsolution  delimiter | }

grant dba to "informix";
grant resource to "public";






create opaque type "informix".sysbldsqltext  
	(
	internallength=variable, 
	maxlen=24000, 
	alignment=1
	);

grant usage on type "informix".sysbldsqltext to 'public' as "informix";

create opaque type "informix".calendarpattern  
	(
	internallength=variable, 
	maxlen=8192, 
	alignment=4
	);

grant usage on type "informix".calendarpattern to 'public' as "informix";

create opaque type "informix".calendar  
	(
	internallength=variable, 
	maxlen=8192, 
	alignment=4
	);

grant usage on type "informix".calendar to 'public' as "informix";

create distinct type "informix".tspartitiondesc_t as  lvarchar ;

grant usage on type "informix".tspartitiondesc_t to 'public' as "informix";

create constructor type "informix".timeseries  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8
	);

grant usage on type "informix".timeseries to 'public' as "informix";

create row type "informix".tscontainerwindow_r 
	(
	tstamp datetime year to fraction(5),
	partition tspartitiondesc_t
	);
grant usage on type "informix".tscontainerwindow_r to 'public' as "informix";

create opaque type "informix".timeseriesmeta  
	(
	internallength=variable, 
	maxlen=512, 
	alignment=4
	);

grant usage on type "informix".timeseriesmeta to 'public' as "informix";

create opaque type "informix".timeseriesaggstate  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8
	);

grant usage on type "informix".timeseriesaggstate to 'public' as "informix";

create opaque type "informix".tsrollup_t  
	(
	internallength=variable, 
	maxlen=1024, 
	alignment=8
	);

grant usage on type "informix".tsrollup_t to 'public' as "informix";

create row type "informix".tsl_flushinfo_r 
	(
	containers integer,
	elements integer,
	duplicates integer,
	instance_ids integer,
	commits integer,
	rollbacks integer,
	exceptions integer,
	errors integer
	);
grant usage on type "informix".tsl_flushinfo_r to 'public' as "informix";

create row type "informix".ts_packed_rowtype_t 
	(
	ts_pack_tstamp datetime year to fraction(5),
	ts_pack_lvarchar lvarchar(32739)
	);
grant usage on type "informix".ts_packed_rowtype_t to 'public' as "informix";

create row type "informix".tsmatchingcount 
	(
	tstamp datetime year to fraction(5),
	count integer
	);
create row type "informix".meter_data 
	(
	tstamp datetime year to fraction(5),
	value decimal(14,3)
	);
grant usage on type "informix".meter_data to 'public' as "informix";

create row type "informix".meter_data2 
	(
	tstamp datetime year to fraction(5),
	value decimal(14,3),
	value2 decimal(14,3)
	);
grant usage on type "informix".meter_data2 to 'public' as "informix";

create opaque type "informix".se_metadata  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8
	);

grant usage on type "informix".se_metadata to 'public' as "informix";

create opaque type "informix".st_geometry  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_geometry to 'public' as "informix";

create opaque type "informix".st_curve  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_curve to 'public' as "informix";

create opaque type "informix".st_multicurve  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_multicurve to 'public' as "informix";

create opaque type "informix".st_surface  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_surface to 'public' as "informix";

create opaque type "informix".st_multisurface  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_multisurface to 'public' as "informix";

create opaque type "informix".st_point  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_point to 'public' as "informix";

create opaque type "informix".st_multipoint  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_multipoint to 'public' as "informix";

create opaque type "informix".st_linestring  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_linestring to 'public' as "informix";

create opaque type "informix".st_multilinestring  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_multilinestring to 'public' as "informix";

create opaque type "informix".st_polygon  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_polygon to 'public' as "informix";

create opaque type "informix".st_multipolygon  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_multipolygon to 'public' as "informix";

create opaque type "informix".st_geomcollection  
	(
	internallength=variable, 
	maxlen=2048, 
	alignment=8, 	
cannothash 
	);

grant usage on type "informix".st_geomcollection to 'public' as "informix";

create row type "informix".address_t 
	(
	address1 char(64),
	city char(32),
	state char(32),
	zipcode integer
	);


create implicit cast (lvarchar as sysbldsqltext with "informix".sysbldsqltextin);

create explicit cast (sysbldsqltext as lvarchar with "informix".sysbldsqltextout);

create explicit cast (sysbldsqltext as sendrecv with "informix".sysbldsqltextsend);

create implicit cast (sendrecv as sysbldsqltext with "informix".sysbldsqltextrecv);

create implicit cast (impexp as sysbldsqltext with "informix".sysbldsqltextimpt);

create explicit cast (sysbldsqltext as impexp with "informix".sysbldsqltextexpt);

create implicit cast (impexpbin as sysbldsqltext with "informix".sysbldsqltextimpb);

create explicit cast (sysbldsqltext as impexpbin with "informix".sysbldsqltextexpb);

create implicit cast (lvarchar as calendarpattern with "informix".calendarpatternin);

create explicit cast (calendarpattern as lvarchar with "informix".calendarpatternout);

create explicit cast (calendarpattern as sendrecv with "informix".calendarpatternsend);

create implicit cast (sendrecv as calendarpattern with "informix".calendarpatternrecv);

create implicit cast (lvarchar as calendar with "informix".calendarin);

create explicit cast (calendar as lvarchar with "informix".calendarout);

create explicit cast (calendar as sendrecv with "informix".calendarsend);

create implicit cast (sendrecv as calendar with "informix".calendarrecv);

create implicit cast (lvarchar as timeseries with "informix".timeseriesin);

create explicit cast (timeseries as lvarchar with "informix".timeseriesout);

create explicit cast (timeseries as sendrecv with "informix".timeseriessend);

create implicit cast (sendrecv as timeseries with "informix".timeseriesrecv);

create explicit cast (tspartitiondesc_t as impexp with "informix".partitionexport);

create implicit cast (impexp as tspartitiondesc_t with "informix".partitionimport);

create implicit cast (timeseriesaggstate as list with "informix".statetolist);

create explicit cast (se_metadata as lvarchar with "informix".se_metadataout);

create explicit cast (se_metadata as sendrecv with "informix".se_metadatasend);

create explicit cast (se_metadata as impexp with "informix".se_metadataexpt);

create explicit cast (se_metadata as impexpbin with "informix".se_metadataexpb);

create implicit cast (lvarchar as se_metadata with "informix".se_metadatain);

create implicit cast (sendrecv as se_metadata with "informix".se_metadatarecv);

create implicit cast (impexp as se_metadata with "informix".se_metadataimpt);

create implicit cast (impexpbin as se_metadata with "informix".se_metadataimpb);

create implicit cast (lvarchar as st_geometry with "informix".st_geomin);

create explicit cast (st_geometry as lvarchar with "informix".st_geomout);

create explicit cast (st_geometry as sendrecv with "informix".st_geomsend);

create implicit cast (sendrecv as st_geometry with "informix".st_geomrecv);

create implicit cast (impexp as st_geometry with "informix".st_geomimpt);

create explicit cast (st_geometry as impexp with "informix".st_geomexpt);

create implicit cast (impexpbin as st_geometry with "informix".st_geomimpb);

create explicit cast (st_geometry as impexpbin with "informix".st_geomexpb);

create implicit cast (lvarchar as st_point with "informix".st_pointin);

create explicit cast (st_point as lvarchar with "informix".st_pointout);

create explicit cast (st_point as sendrecv with "informix".st_pointsend);

create implicit cast (sendrecv as st_point with "informix".st_pointrecv);

create implicit cast (impexp as st_point with "informix".st_pointimpt);

create explicit cast (st_point as impexp with "informix".st_pointexpt);

create implicit cast (impexpbin as st_point with "informix".st_pointimpb);

create explicit cast (st_point as impexpbin with "informix".st_pointexpb);

create implicit cast (lvarchar as st_polygon with "informix".st_polyin);

create explicit cast (st_polygon as lvarchar with "informix".st_polyout);

create explicit cast (st_polygon as sendrecv with "informix".st_polysend);

create implicit cast (sendrecv as st_polygon with "informix".st_polyrecv);

create implicit cast (impexp as st_polygon with "informix".st_polyimpt);

create explicit cast (st_polygon as impexp with "informix".st_polyexpt);

create implicit cast (impexpbin as st_polygon with "informix".st_polyimpb);

create explicit cast (st_polygon as impexpbin with "informix".st_polyexpb);

create implicit cast (lvarchar as st_linestring with "informix".st_linein);

create explicit cast (st_linestring as lvarchar with "informix".st_lineout);

create explicit cast (st_linestring as sendrecv with "informix".st_linesend);

create implicit cast (sendrecv as st_linestring with "informix".st_linerecv);

create implicit cast (impexp as st_linestring with "informix".st_lineimpt);

create explicit cast (st_linestring as impexp with "informix".st_lineexpt);

create implicit cast (impexpbin as st_linestring with "informix".st_lineimpb);

create explicit cast (st_linestring as impexpbin with "informix".st_lineexpb);

create implicit cast (lvarchar as st_multilinestring with "informix".st_mlinein);

create explicit cast (st_multilinestring as lvarchar with "informix".st_mlineout);

create explicit cast (st_multilinestring as sendrecv with "informix".st_mlinesend);

create implicit cast (sendrecv as st_multilinestring with "informix".st_mlinerecv);

create implicit cast (impexp as st_multilinestring with "informix".st_mlineimpt);

create explicit cast (st_multilinestring as impexp with "informix".st_mlineexpt);

create implicit cast (impexpbin as st_multilinestring with "informix".st_mlineimpb);

create explicit cast (st_multilinestring as impexpbin with "informix".st_mlineexpb);

create implicit cast (lvarchar as st_multipoint with "informix".st_mpointin);

create explicit cast (st_multipoint as lvarchar with "informix".st_mpointout);

create explicit cast (st_multipoint as sendrecv with "informix".st_mpointsend);

create implicit cast (sendrecv as st_multipoint with "informix".st_mpointrecv);

create implicit cast (impexp as st_multipoint with "informix".st_mpointimpt);

create explicit cast (st_multipoint as impexp with "informix".st_mpointexpt);

create implicit cast (impexpbin as st_multipoint with "informix".st_mpointimpb);

create explicit cast (st_multipoint as impexpbin with "informix".st_mpointexpb);

create implicit cast (lvarchar as st_multipolygon with "informix".st_mpolyin);

create explicit cast (st_multipolygon as lvarchar with "informix".st_mpolyout);

create explicit cast (st_multipolygon as sendrecv with "informix".st_mpolysend);

create implicit cast (sendrecv as st_multipolygon with "informix".st_mpolyrecv);

create implicit cast (impexp as st_multipolygon with "informix".st_mpolyimpt);

create explicit cast (st_multipolygon as impexp with "informix".st_mpolyexpt);

create implicit cast (impexpbin as st_multipolygon with "informix".st_mpolyimpb);

create explicit cast (st_multipolygon as impexpbin with "informix".st_mpolyexpb);

create implicit cast (lvarchar as st_surface with "informix".st_surfacein);

create explicit cast (st_surface as lvarchar with "informix".st_surfaceout);

create explicit cast (st_surface as sendrecv with "informix".st_surfacesend);

create implicit cast (sendrecv as st_surface with "informix".st_surfacerecv);

create implicit cast (impexp as st_surface with "informix".st_surfaceimpt);

create explicit cast (st_surface as impexp with "informix".st_surfaceexpt);

create implicit cast (impexpbin as st_surface with "informix".st_surfaceimpb);

create explicit cast (st_surface as impexpbin with "informix".st_surfaceexpb);

create implicit cast (lvarchar as st_multisurface with "informix".st_msurfacein);

create explicit cast (st_multisurface as lvarchar with "informix".st_msurfaceout);

create explicit cast (st_multisurface as sendrecv with "informix".st_msurfacesend);

create implicit cast (sendrecv as st_multisurface with "informix".st_msurfacerecv);

create implicit cast (impexp as st_multisurface with "informix".st_msurfaceimpt);

create explicit cast (st_multisurface as impexp with "informix".st_msurfaceexpt);

create implicit cast (impexpbin as st_multisurface with "informix".st_msurfaceimpb);

create explicit cast (st_multisurface as impexpbin with "informix".st_msurfaceexpb);

create implicit cast (lvarchar as st_curve with "informix".st_curvein);

create explicit cast (st_curve as lvarchar with "informix".st_curveout);

create explicit cast (st_curve as sendrecv with "informix".st_curvesend);

create implicit cast (sendrecv as st_curve with "informix".st_curverecv);

create implicit cast (impexp as st_curve with "informix".st_curveimpt);

create explicit cast (st_curve as impexp with "informix".st_curveexpt);

create implicit cast (impexpbin as st_curve with "informix".st_curveimpb);

create explicit cast (st_curve as impexpbin with "informix".st_curveexpb);

create implicit cast (lvarchar as st_multicurve with "informix".st_mcurvein);

create explicit cast (st_multicurve as lvarchar with "informix".st_mcurveout);

create explicit cast (st_multicurve as sendrecv with "informix".st_mcurvesend);

create implicit cast (sendrecv as st_multicurve with "informix".st_mcurverecv);

create implicit cast (impexp as st_multicurve with "informix".st_mcurveimpt);

create explicit cast (st_multicurve as impexp with "informix".st_mcurveexpt);

create implicit cast (impexpbin as st_multicurve with "informix".st_mcurveimpb);

create explicit cast (st_multicurve as impexpbin with "informix".st_mcurveexpb);

create implicit cast (lvarchar as st_geomcollection with "informix".st_geomcollin);

create explicit cast (st_geomcollection as lvarchar with "informix".st_geomcollout);

create explicit cast (st_geomcollection as sendrecv with "informix".st_geomcollsend);

create implicit cast (sendrecv as st_geomcollection with "informix".st_geomcollrecv);

create implicit cast (impexp as st_geomcollection with "informix".st_geomcollimpt);

create explicit cast (st_geomcollection as impexp with "informix".st_geomcollexpt);

create implicit cast (impexpbin as st_geomcollection with "informix".st_geomcollimpb);

create explicit cast (st_geomcollection as impexpbin with "informix".st_geomcollexpb);

create implicit cast (st_curve as st_geometry);

create explicit cast (st_curve as st_linestring);

create explicit cast (st_geometry as st_curve);

create explicit cast (st_geometry as st_geomcollection);

create explicit cast (st_geometry as st_linestring);

create explicit cast (st_geometry as st_multicurve);

create explicit cast (st_geometry as st_multilinestring);

create explicit cast (st_geometry as st_multipoint);

create explicit cast (st_geometry as st_multipolygon);

create explicit cast (st_geometry as st_multisurface);

create explicit cast (st_geometry as st_point);

create explicit cast (st_geometry as st_polygon);

create explicit cast (st_geometry as st_surface);

create implicit cast (st_geomcollection as st_geometry);

create explicit cast (st_geomcollection as st_multicurve);

create explicit cast (st_geomcollection as st_multilinestring);

create explicit cast (st_geomcollection as st_multipoint);

create explicit cast (st_geomcollection as st_multipolygon);

create explicit cast (st_geomcollection as st_multisurface);

create implicit cast (st_linestring as st_curve);

create implicit cast (st_linestring as st_geometry);

create implicit cast (st_multicurve as st_geometry);

create implicit cast (st_multicurve as st_geomcollection);

create explicit cast (st_multicurve as st_multilinestring);

create implicit cast (st_multilinestring as st_geometry);

create implicit cast (st_multilinestring as st_geomcollection);

create implicit cast (st_multilinestring as st_multicurve);

create implicit cast (st_multipoint as st_geometry);

create implicit cast (st_multipoint as st_geomcollection);

create implicit cast (st_multipolygon as st_geometry);

create implicit cast (st_multipolygon as st_geomcollection);

create implicit cast (st_multipolygon as st_multisurface);

create implicit cast (st_multisurface as st_geometry);

create implicit cast (st_multisurface as st_geomcollection);

create explicit cast (st_multisurface as st_multipolygon);

create implicit cast (st_point as st_geometry);

create implicit cast (st_polygon as st_geometry);

create implicit cast (st_polygon as st_surface);

create implicit cast (st_surface as st_geometry);

create explicit cast (st_surface as st_polygon);



create aggregate "informix".tssettolist with
	(
	INIT = ts_agg_init,
	ITER = ts_agg_iter,
	COMBINE = ts_agg_combine,
	FINAL = ts_agg_final
	);

create aggregate "informix".tscolnumtolist with
	(
	INIT = ts_agg_colnum_init,
	ITER = ts_agg_colnum_iter,
	COMBINE = ts_agg_colnum_comb,
	FINAL = ts_agg_colnum_fin,
	handlesnulls
	);

create aggregate "informix".tscolnametolist with
	(
	INIT = ts_agg_colnam_init,
	ITER = ts_agg_colnam_iter,
	COMBINE = ts_agg_colnam_comb,
	FINAL = ts_agg_colnam_fin,
	handlesnulls
	);

create aggregate "informix".tsrowtolist with
	(
	INIT = ts_agg_row_init,
	ITER = ts_agg_row_iter,
	COMBINE = ts_agg_row_comb,
	FINAL = ts_agg_row_fin,
	handlesnulls
	);

create aggregate "informix".tsrownumtolist with
	(
	INIT = ts_agg_rownum_init,
	ITER = ts_agg_rownum_iter,
	COMBINE = ts_agg_rownum_comb,
	FINAL = ts_agg_rownum_fin,
	handlesnulls
	);

create aggregate "informix".tsrownametolist with
	(
	INIT = ts_agg_rownam_init,
	ITER = ts_agg_rownam_iter,
	COMBINE = ts_agg_rownam_comb,
	FINAL = ts_agg_rownam_fin,
	handlesnulls
	);

create aggregate "informix".tsrollup with
	(
	INIT = tsrollup_init,
	ITER = tsrollup_iter,
	COMBINE = tsrollup_combine,
	FINAL = tsrollup_final,
	handlesnulls
	);

create aggregate "informix".se_dissolve with
	(
	INIT = se_dissolve_init,
	ITER = se_dissolve_iter,
	COMBINE = se_dissolve_combine,
	FINAL = se_dissolve_final
	);


create function "informix".sysbldsqltextin (lvarchar)
returns SYSBldSQLText
external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextIn)'
language c;

create function "informix".sysbldsqltextout (SYSBldSQLText)
returns lvarchar
external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextIn)'
language c;

create function "informix".sysbldsqltextsend (SYSBldSQLText)
returns sendrecv
external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextOut)'
language c;

create function "informix".sysbldsqltextrecv (sendrecv)
returns SYSBldSQLText
external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextIn)'
language c;

create function "informix".sysbldsqltextimpt (impexp)
returns SYSBldSQLText
external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextIn)'
language c;

create function "informix".sysbldsqltextexpt (SYSBldSQLText)
returns impexp
external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextOut)'
language c;

create function "informix".sysbldsqltextimpb (impexpbin)
returns SYSBldSQLText
external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextIn)'
language c;

create function "informix".sysbldsqltextexpb (SYSBldSQLText)
returns impexpbin
external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextOut)'
language c;

create function "informix".equal   (SYSBldSQLText,SYSBldSQLText)
returns boolean
external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextEqual)'
language c;

create function "informix".sysbldlike  (SYSBldSQLText,SYSBldSQLText)
returns boolean
external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextLike)'
language c;

create function "informix".sysbldprepare () returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldPrepare2)' 
				language C variant;

create function "informix".sysbldregister(CHAR(64), CHAR(18)) returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldRegister)' 
				language C variant;

create function "informix".sysbldregister(CHAR(64)) returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldRegister2)' 
				language C variant;

create function "informix".sysbldunregister(CHAR(64), CHAR(18)) returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldUnregister)' 
				language C variant;

create function "informix".sysbldunregister(CHAR(64)) returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldUnregister2)' 
				language C variant;

create function "informix".sysbldtrace (CHAR(64), integer) returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSetTraceFile)' 
				language C variant;

create function "informix".sysbldtrace (integer) returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSetTraceFile2)' 
				language C variant;

create function "informix".sysbldcleanuptables() returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldCleanupTables)' 
				language C variant;

create function "informix".sysbldrelease () returns lvarchar 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(MackRelease)' 
				language C not variant;

create function "informix".sysbldgetsrvrfile(lvarchar, lvarchar) returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(FetchSrvrFile)' 
				language C variant;

create function "informix".sysbldlstbldtoprep() returns lvarchar 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(LstBldToPrep)' 
				language C variant;

create function "informix".sysbldprepblade(lvarchar) returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(PrepBlade)' 
				language C variant;

create function "informix".sysbldtstsbspace (lvarchar) returns integer
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldTstSBSpace)'
				language c variant;

create function "informix".sysbldtstvp  (lvarchar) returns integer
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldTstVP)'
				language c variant;

create function "informix".sysbldunprepare() returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldUnPrepare)' 
				language C variant;

create function "informix".sysbldaddblddir(lvarchar, lvarchar) returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldAddBldDir)' 
				language C variant;

create function "informix".sysbldputsrvrfile(lvarchar, lvarchar) returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldPutSrvrFile)' 
				language C variant;

create function "informix".sysbldgetanysrvrfile(lvarchar, lvarchar) returns integer 
				external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldGetAnySrvrFile)' 
				language C variant;

create function "informix".sysbldhtmltableize(lvarchar,lvarchar) returns integer
	external name '$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldHTMLTableize)' language c;

create function "informix".sysbldhtmlobjdependents(lvarchar,lvarchar) returns integer
	external name "$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldHTMLObjDependents)" language c;

create function "informix".sysbldhtmlobjdependencies(lvarchar,lvarchar) returns integer
	external name "$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldHTMLObjDependencies)" language c;

create function "informix".sysbldhtmlblddependencies(lvarchar,lvarchar) returns integer
	external name "$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldHTMLBldDependencies)" language c;

create function "informix".sysbldhtmlbeginfile(lvarchar,lvarchar) returns integer
	external name "$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldHTMLBeginFile)" language c;

create function "informix".sysbldhtmlendfile(lvarchar) returns integer
	external name "$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldHTMLEndFile)" language c;

create function "informix".sysbldhtmlbldobjs(lvarchar,lvarchar) returns integer
	external name "$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldHTMLBldObjs)" language c;

create function "informix".calendarpatternin (lvarchar)
returns CalendarPattern with (not variant)
external name "$INFORMIXDIR/extend/TimeSeries.6.00.FC9/TimeSeries.bld(ts_cal_pattern_input)" language c;

create function "informix".calendarpatternout (CalendarPattern)
returns lvarchar with (not variant)
external name "$INFORMIXDIR/extend/TimeSeries.6.00.FC9/TimeSeries.bld(ts_cal_pattern_output)" language c;
-- Incompatible blade version (import TimeSeries.6.00.FC9; available TimeSeries.6.01.FC2)