CREATE TABLE TempCodes (CodeRef VARCHAR(3), DESCRIPTION VARCHAR(10))

INSERT INTO TempCodes VALUES ('C01','Red')

INSERT INTO TempCodes VALUES ('C','Green')

INSERT INTO TempCodes VALUES ('D9','purple')

INSERT INTO TempCodes VALUES ('D','yellow')

INSERT INTO TempCodes VALUES ('C08','black')

CREATE TABLE TempData (Reference...

an idea: use no cashing instead of full precaching, the default caching type

No caching, in which the reference dataset is accessed by each row in the rowset. To configure...