SQL SQLORA
SELECT TWR_1M 
FROM U_CA_REP;
END

SQL SQLORA
SELECT CAST(TWR_1M AS NUMERIC(10,4)) 
FROM U_CA_REP;
END

SQL SQLORA
SELECT 
CASE WHEN TWR_1M = 0 OR TWR_1M IS NULL THEN NULL
ELSE CAST(TWR_1M AS NUMERIC(10,4)) AS RET_1M 
FROM U_CA_REP;
END

quote:

The following example shows how to set the precision attribute for all INTEGER and SMALLINT
fields to 7:
ENGINE SQLORA SET CONVERSION INTEGER PRECISION 7
The following example shows how to set the precision attribute for all DOUBLE PRECISION
fields to 14 and the scale attribute to 3:
ENGINE SQLORA SET CONVERSION FLOAT PRECISION 14 3
The following example shows how to set the precision attribute for all INTEGER and SMALLINT
fields to the default:
ENGINE SQLORA SET CONVERSION INTEGER RESET
The following example shows how to set the precision and scale attributes for all fields to
the defaults:
ENGINE SQLORA SET CONVERSION RESET

ENGINE SQLORA SET DATETIME OFF
ENGINE SQLORA SET VARCHAR OFF
ENGINE SQLORA SET FETCHSIZE 1000

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

ENGINE SQLORA SET CONVERSION FLOAT PRECISION x y

 OPTIMIZATION    
 OPTIFTHENELSE    
 FETCHSIZE      
 INSERTSIZE      
 AGGREGATE_AWARENESS    
 
Controlling Session Parameters  
 AUTODISCONNECT    
 NONBLOCK      

Miscellaneous Settings  
 PASSRECS    
 

SQL SQLORA
SELECT 
   CAST(
      CASE WHEN TWR_1M = 0 OR TWR_1M IS NULL THEN NULL
      ELSE TWR_1M 
      END
   AS NUMBER(10,4)) RET_1M 
FROM U_CA_REP;
END