How to assign a number using sql to a DFF?
Need to assign a 5 digit number using sql to supplier DFF
we have a DFF called address_indicator where we need to populate it with 5-digit number, and everytime a new entry is created, it increases by 1. So for 1st address when created, it should automatically be 10000, then when second address is created it should automatically be 100001 and so on.
we have selected default type as SQL under DFF, but not sure how to write that sql.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):