Re: Using convert weight files in SQL

How does JDE do it? For example if in their code they call an RPG
subprocedure then wrap a UDF around that subprocedure and place that into
your statement. Search faq.midrange.com for UDF.

Otherwise

CREATE TABLE ROB/CONVERT
(FROMUM CHAR (2 ) NOT NULL,
TOUM CHAR (2 ) NOT NULL,
FACTOR DEC (10 , 5) NOT NULL,
PRIMARY KEY (FROMUM, TOUM),
CHECK (FROMUM <>' ' ),
CHECK (toum<>' ' ),
CHECK (FACTOR <>0 ))

INSERT...

....+....1....+....2....+.
FROMUM TOUM FACTOR
KG DK .01000
DK KG 100.00000
TN KG 1,000.00000
KG TN .00100
KG G .00100
G KG 1,000.00000
DK DK 1.00000
KG KG 1.00000
TN TN 1.00000
G G 1.00000
******** End of data ***

SELECT ITEM#, WEIGHT, UM, TOUM,
WEIGHT * FACTOR
FROM ITDTL JOIN CONVERT ON FROMUM=UM AND TOUM='TN'

....+....1....+....2....+....3....+....4....+....5....+....6....+....7
ITEM# WEIGHT UM TOUM WEIGHT * FACTOR
A 7.50000 KG TN .0075000000
******** End of data ********




Rob Berendt