Informix

 View Only
  • 1.  how to execute tspurgefunction for rolling container

    Posted 22 days ago
    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
    ------------------------------


  • 2.  RE: how to execute tspurgefunction for rolling container

    IBM Champion
    Posted 22 days ago
    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
    ------------------------------