Code: |
UPDATE DB2T.OUR_CUST SET HUB_CUST_ID = CHAR('HUB-'||SUBSTR(ZIP_OR_POSTAL_CDE,1,5)||CHAR('-')|| SUBSTR(CIN_CUST_ID,1,9)) WHERE ENTY_ID = 'YYYY' AND AREA_ID = 'ZZZZ' AND CIN_CUST_ID > ' ' AND CIN_CUST_ID < '000061836' AND ZIP_OR_POSTAL_CDE > ' ' AND ADR_LINE_3 > ' ' AND HUB_CUST_ID = ' ' AND EXPR_DTE = '9999-12-31' ; |
Code: |
----+----1----+----2----+----3----+----4----+----5----+----6 UPDATE DB2T.OUR_CUST SET HUB_CUST_ID = CHAR(('HUB-') || SUBSTR(ZIP_OR_POSTAL_CDE,1,5) || CHAR('-') || SUBSTR(CIN_CUST_ID,1,9)) WHERE ENTY_ID = 'YYYY' AND AREA_ID = 'ZZZZ' AND CIN_CUST_ID > ' ' AND CIN_CUST_ID < '000061836' AND ZIP_OR_POSTAL_CDE > ' ' AND ADR_LINE_3 > ' ' AND HUB_CUST_ID = ' ' AND EXPR_DTE = '9999-12-31' ; |
output generated using printer-friendly topic mod. All times are GMT - 5 Hours