How can I convert an Image J2 currency amount to a correctly-formatted text string ?
An Image J2 data type, like an Image I2, is an integer data type with an implied decimal point. To convert this value to a text string with a decimal point followed by two decimal places, see the following script output : 1> define j : image j2 value 9999 2> define s : string 3> setvar s = trunc ( ( convert( j , “oracle number”) / 100 ), 2) 4> print s 99.99 Is there a way of determining how long it takes for the Warehouse engine to compile the Warehouse script and open the databases ? What you are asking to measure is the elapsed time required by the Warehouse engine to compile a script, a phase that also includes opening both local and remote data sources and targets and preparing the SQL statements. The mechanism to gather this measurement is platform-dependent. One approach that could be taken on Unix is to insert two lines at the beginning of the script. The first line begins with an exclamation mark and executes at compile-time. Since it is the first compile-time statement in the
