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



This was last published in May 2003

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: