Precisely Enterworks

 View Only
Back to discussions
Expand all | Collapse all

Adding a new codeset value automatically from another source dataset

  • 1.  Adding a new codeset value automatically from another source dataset

    Posted 02-24-2023 16:03

    I have new codeset values being created in our ERP's quite frequently and I'll like to know the best method by which to automatically add these to our Enterworks environments.

    Our ERP system is in an Azure database (replicating from our source AS400 environment).    I have SQL's which give me the new codeset values and descriptions, I just need a good method to add them into Enterworks.

    Currently I'm exploring using a stored proc based in the EPIM db to add them directly into the B_CODE_SET_DETAIL table along with the applicable id's needed to create a new code, but is this a good idea?



    ------------------------------
    Rick Spencer | PIM Systems Administrator
    Animal Supply Company | 972-474-6949
    ------------------------------