Skip to main content
Question

Archive not working with user defined column

  • December 8, 2022
  • 1 reply
  • 24 views

Forum|alt.badge.img+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

Jon Reid
Hero (Employee)
Forum|alt.badge.img+18
  • Hero (Employee)
  • 224 replies
  • December 8, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings