Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
nasiha zailan — source: IBM Community (ConnectedCommunity.org) Informix forum
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
↪ replying to nasiha zailan
Mike Walker — source: IBM Community (ConnectedCommunity.org) Informix forum
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
------------------------------
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.