Avatar

Correct answer by
Level 5

Hi Erik,

you could create mutilple sequences in SQL scripts like this :

SQL script sequence.png

And by defining an SQL function to get the next value of your sequences (Adding additional SQL functions:disappointed_face:

<?xml version="1.0" encoding='ISO-8859-1' ?>

<!-- ===========================================================================

  Additional SQL functions for Adobe Campaign

  ========================================================================== -->

<package

  namespace   = "nms"

  name        = "package-funclist-nextSeqVal"

  label       = "nextSeqVal function"

  buildVersion= "6.1"

  buildNumber = "8721">

  <entities schema="xtk:funcList">

    <funcList name="sequenceFunctions" namespace="crf">

      <group name="numeric" label="Numerical">

        <function name="nextSeqVal" type="long" args="(&lt;SequenceName&gt;)" help="get next value of specified sequence ex.: nextSeqVal('negativePersonID')"

                  minArgs="1" maxArgs="1" display="Get next value of sequence '$1'">

          <providerPart provider="PostgreSQL,MSSQL" body="nextval($1)"/>

        </function>

      </group>

    </funcList>

  </entities>

</package>

You can then use the sequence of your choice :

Update Data with Sequence.png

Kind regards,

Pierre

View solution in original post