Start a new topic
Discussions xDM xDM - Integration
Answered

How to reference a sequence in a custom function, which I will then populate as an attribute in Semarchy?

How to reference a sequence in a custom function, which I will then populate as an attribute in Semarchy?

Best Answer

Follow these steps to generate a sequence value and populate it in an attribute. 

  1. Create a custom sequence in that database.
  2. Call the sequence using sequence.NEXTVAL in your function.
  3. You can then return the next sequence val in your function
  4. Create a new database function in the Semarchy app builder
  5. Once the function is created in Semarchy, create an enricher, which can populate the attribute with the returned value in your function.
1 Comment
Answer

Follow these steps to generate a sequence value and populate it in an attribute. 

  1. Create a custom sequence in that database.
  2. Call the sequence using sequence.NEXTVAL in your function.
  3. You can then return the next sequence val in your function
  4. Create a new database function in the Semarchy app builder
  5. Once the function is created in Semarchy, create an enricher, which can populate the attribute with the returned value in your function.
Login to post a comment
More topics in xDM - Integration
See all 82 topics
Help Desk Software by Freshdesk