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
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)
Related Q&A from Kent Milligan
To monitor members stuck within a physical file on AS/400, you can periodically use the display file description (DSPFD) command to create an output ...continue reading
Create a host variable of the where in statement on the fly with dynamic SQL.continue reading
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.