When using the "SUM" function in SQL, how do I override the systems default length of the field? Example: sum(widget_qty) as qty
The system generates a field length of 31,0. I would like it to be 9,0. This is causing a problem with my SQLRPGLE program, which will not compile due to the 31 position field length.
You just need to wrapper the SUM function with the CAST function. For example: CAST(SUM(widget_qty) AS DECIMAL(9,0)) as qty
================================== MORE INFORMATION ON THIS TOPIC ==================================
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.
This was first published in May 2003