ProTech's home page

ProTech-Online.com

IBM DB2 SQL code example to pull Quantus BOM number of operations.

CREATE FUNCTION TEST_BOM_COUNT( @BRANCH VARCHAR(8), @ITEMNUM VARCHAR(32) )
    RETURNS INTEGER
    SPECIFIC BOM_COUNT
    LANGUAGE SQL
    READS SQL DATA
    NO EXTERNAL ACTION
    RETURN
       SELECT
           COUNT(*)      
       FROM QUANTUS.ASSEMBLY_OPTION
           INNER JOIN QUANTUS.INVENTORY ON QUANTUS.ASSEMBLY_OPTION.BRANCH = QUANTUS.INVENTORY.BRANCH
               AND QUANTUS.ASSEMBLY_OPTION.PARENTITEMNUM = QUANTUS.INVENTORY.ITEMNUM
       WHERE
           LTRIM(QUANTUS.ASSEMBLY_OPTION.BRANCH) = @BRANCH AND
           UPPER(LTRIM(QUANTUS.ASSEMBLY_OPTION.PARENTITEMNUM)) = UPPER(LTRIM(@ITEMNUM))AND
           QUANTUS.ASSEMBLY_OPTION.OPCODE = 'BOM' AND
           QUANTUS.ASSEMBLY_OPTION.TYPE = 'W'


Copyright © 2013 ProTechs-Online.com; All rights reserved.