- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Erik,
you could create mutilple sequences in SQL scripts like this :
And by defining an SQL function to get the next value of your sequences (Adding additional SQL functions![]()
<?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="(<SequenceName>)" 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 :
Kind regards,
Pierre