SeanHoppe.com › Code Samples › Duplicate Value Checking in F4211<
Formula - Duplicate value checking in F47011
Just as we can check for duplicate records in F4201, we can check for duplicate records in F47011 before EXTOL translates inbound data.
In addition to using an EXTOL Formula we will use an EXTOL EFL (External File Lookup) with a customized logical file of F47011.
DDS source:Logical File: F47011_3
- SYSHAN
- SYEKCO
- SYVR01
Formula Set-up
V:= C || D,if a > b then [ADDMSGTXT MSG('Duplicate PO# in F47011. Purchase Order #
:&E DOCO:&F') TOMSGQ(&V)]
ELSE
ENDIF
Parameters:
By: Sean Hoppe on
