on 04-09-2015 10:48 AM
Hi Everyone,
Does MDO has any ID property similar to transactionid function in MII that gets incremented after each execution cycle? We are inserting the data in MDO and would like to have one column as ID which contains value such as 1 to refer to first insertion, 2 to refer to 2nd insertion and so on...How can we achieve this using MDOs?
Thanks,
Rajeev
Thanks for your inputs
Actually, the sequencing can be implemented by using a persistent variable and using an Assignment block as a counter..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajeev,
You have some default columns with an MDO that records insert timestamp. You can make use of it.
Thanks,
Swaroop
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No Rajeev,
There is a set of columns that gets created automatically for every MDO created for insertion(the one that doesn't have data source). You would be able to see those in your MDO select query not on MDO object.
Please find the image below for reference. You can make use of these columns.
Thanks,
Swaroop
User | Count |
---|---|
11 | |
6 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.