- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Yes, it will create a new sequence called NeoCustomId in your sequence table which is XtkNewId.
I'm assuming that you have Schemas created with autopk but not specifying sqlSequence.
If you have a recent build (starting from 18.4) of ACC you should be covered.
This feature is implemented through a new API: GenCreateOrUpdateSchemaSequenceDDL.
This API generates the SQL script used to create or update autopk schema sequence:
GenCreateOrUpdateSchemaSequenceDDL(schemaID, newSequenceName, oldSequenceName)
- schemaID (mandatory): "<nameSpace>:<schemaName>"
- newSequenceName (mandatory): new sequence name
- oldSequenceName (optional): old sequence name
example: GenCreateOrUpdateSchemaSequenceDDL("cus:contacts", "myContactsSeq", "XtkNewId")
In this case, the new sequence will begin from the largest ID of the schema.
Also please view webinar - Adobe Campaign Classic - Sequences Exhaustion for more insights
Thanks,
David
Views
Replies
Total Likes