In the data category Commodities in Datastream you can find the spot prices of metals, energy, chemicals, softs (like cocoa) etc. However picking the ‘right’ one can be difficult, for example a search for oil gives 5734 results.
In Datastream’s Extranet you can find Top 30 commodities benchmark series, a list of the main spot prices for a variety of commodities, like crude oil, gold and cotton.
Another option is to use the Commodities Explorer in Datastream Navigator. The explorer offers a ‘guided search’: the commodities are grouped by topic.
When you are searching for the spot price of a commodity and you also need future prices, then first request the futures and use the datatype FUI (underlying instrument) in a static request to get the Mnemonic of the underlying commodity.