Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

"SUM" function in SQL

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 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.



Dig Deeper on DB2 UDB (universal databases)