This page (revision-21) was last changed on 18-Aug-2023 12:06 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by Kevin Higgs

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
21 18-Aug-2023 12:06 7 KB Kevin Higgs to previous

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 5 removed one line
At line 10 changed one line
All samples show the required fields only to insert a new record. Additional fields to be updated may be added to these interfaces provided they are found on the subject table being updated.\\
All samples show the required fields only to insert a new record. Additional fields to be updated may be added to these interfaces provided they are found on the subject table being updated.
At line 12 removed 2 lines
!!DISABLE TRIGGERS
If doing a __mass upload__ of data to a table containing workflow triggers, it is highly recommended to disable those triggers prior to performing the load. \\
At line 15 removed 4 lines
1) Prior to load - __ALTER TRIGGER P2K_XXXX_BIUD DISABLE;__\\
2) Complete the load\\
3) After the load - __ALTER TRIGGER P2K_XXXX_BIUD ENABLE;__\\
\\
At line 41 removed one line
||Rec\\ #||Field\\ #||Name||Beg\\ Pos|| End\\ Pos||Field\\ Type||Record\\ Type||Add to\\UK Set||Constant\\ Value||Derivation\\ Expression||Notes
At line 93 changed one line
;:NOTE: this process will allow the update of [User Defined Columns|USER DEFINED COLUMN|USER DEFINED COLUMN (UDC)], but will not be able to update [User Defined Fields|USER DEFINED FIELD].
;:NOTE: this process will allow the update of [User Defined Columns|USER DEFINED COLUMN], but will not be able to update [User Defined Fields|USER DEFINED FIELD].
At line 103 changed one line
|P2K_CM_GROUP_DETAILS|DGD|IDGR|DGD.DGR_ID.GROUP_CODE,\\DGD.DGR_ID.DUN_ID.UNIT_CODE,\\DGD.EFFECTIVE
|P2K_CM_GROUP_DETAILS|DGRD|IDGR|DGD.DGR_ID.GROUP_CODE,\\DGD.DGR_ID.DEN_ID.ENTITY_CODE,\\DGRD.EFFECTIVE