How to generate a unique id for an external table
Hi All,
I have a data class in Pega for which there is an external table in Pega DB. Every time a record is inserted into the table, I need to have a unique id for the record. Can anyone tell me how to accomplish this requirement?
There is OOTB GenerateID activity which looks for the highest ID in the table and fetches the ID for the work objects, but I have to embed this logic in file processing. After parsing each record in the file I need to insert the same data into a table and there will be millions of records. So using an activity with Java step might impact the performance
Please provide your suggestions.
Thanks
Pegasystems Inc.
US
Another option is to create a SEQUENCE on the DB side and for the insert SQL, use <sequence>.NEXTVAL for the primary key
Updated: 6 May 2016 1:25 EDT
ANZ Banking Group
AU
Have the pxObjClass,pzinskey,pxCreateDateTime defined as the columns in the DB table. Have the pzInsKey as the primary key of the table. When you do an Obj-Save to save the data instance pzInskey is auto generated and saved in the table.
Pegasystems Inc.
IN
Hi Anusha, Good morning!
would any of the following functions be of help?
- @Default.GenerateID(Prefix)
- @Default.CreateUniqueID()
- @DateTime.getCurrentTimeStampUnique()
- @java("java.util.UUID.randomUUID().toString()")
Please share your thoughts/comments, Thank you!
psahukaru