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'