Informix

so, i tried to load creates a control file named regular_purge.unl to delete elements from time series instances:
but it return error 674: routine(getcontainername) cannot be resolved. 

UNLOAD TO 'regular_purge.unl'
SELECT GetContainerName(para_id),InstanceId(para_id),
GetIndex(para_id,'2011-10-01 23:45:00.00000'::datetime year to
fraction(5))::varchar(25)
FROM meter_ts_tbl ;

------------------------------
nasiha zailan
------------------------------

#Informix

This worked for me against my timeseries database.

Is "para_id" the timeseries column in the meter_ts_tbl, and not just the key of the table?


------------------------------
Mike Walker
xDB Systems, Inc
www.xdbsystems.com
------------------------------

Original Message:
Sent: Thu June 09, 2022 05:41 AM
From: nasiha zailan
Subject: how to execute tspurgefunction for rolling container

so, i tried to load creates a control file named regular_purge.unl to delete elements from time series instances:
but it return error 674: routine(getcontainername) cannot be resolved. 

UNLOAD TO 'regular_purge.unl'
SELECT GetContainerName(para_id),InstanceId(para_id),
GetIndex(para_id,'2011-10-01 23:45:00.00000'::datetime year to
fraction(5))::varchar(25)
FROM meter_ts_tbl ;

------------------------------
nasiha zailan
------------------------------

#Informix