Question

Archive not working with user defined column

  • 8 December 2022
  • 1 reply
  • 23 views

Userlevel 1
Badge +4

Archive get only working with created_dttm. For user defined column name it is not working e.g user_def_dttm5

Below script not working with user_def_dttm5

<perform_archive_table>

  <parameters>

    <table_name>TASK</table_name>

    <archive_dttm />

    <mrl_update_period />

  </parameters>

</perform_archive_table>

 

Please suggest how we can configure with user defined column name


1 reply

Userlevel 6
Badge +17

You would need to specify user_def_dttm5 as the Archive Date Coumn instead of CREATED_DTTM, then pass in a date value for archive_dttm - in your example above the archive_dttm parameter is empty.

Reply