Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Creating a sequence

More
06 Jan 2016 13:36 #1 by Prudence
Creating a sequence was created by Prudence
Hello,
I use a few days stambia and I am trying to reproduce the utlisation tutorials manuals.
I want to know how to create an incremental-séquenceauto to put in a target datastore.
thanks for your help
More
08 Jan 2016 09:57 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Creating a sequence
Hello,

There can be several solutions.
Maybe you can rely on the database's functions.
For example with Oracle you can use an Oracle Sequence. With SqlServer you can use an Identity column. With MySQL you can use auto_increment, etc.

An idea with Oracle : create a Metadata Variable with a refresh query like "SELECT some_sequence.nextval FROM dual".

Feel free to share more details on what you need to do if the above does not help :)
More
12 Jan 2016 11:08 #3 by Prudence
Replied by Prudence on topic Creating a sequence
thank you for your ideas, the problem was that I called a sequence that had not yet created