sql - 查询定义字段的设置格式

Question

我在输出到文件的 iSeries SQL 中有以下查询。

SELECT SSLOTMAK, SSLOTMDL, SSLOTYER, sum(SSCOUNT)       
FROM prqhdrss                                                      
GROUP BY SSLOTMAK, SSLOTMDL, SSLotyer 
HAVING sum(SSCOUNT) > 4 
ORDER BY SSLOTMAK, SSLOTMDL, SSLOTYER                                    

当我运行它时，创建的字段是 sum(SSCOUNT) 是一个 31 Packed 字段。这不允许我将它发送到我的电脑。我如何强制 SQL 将该字段创建为非压缩字段。

Answer 1

试试这个

SELECT SSLOTMAK, SSLOTMDL, SSLOTYER, cast(sum(SSCOUNT) as integer)
FROM prqhdrss
GROUP BY SSLOTMAK, SSLOTMDL, SSLotyer
HAVING sum(SSCOUNT) > 4
ORDER BY SSLOTMAK, SSLOTMDL, SSLOTYER

由于“计数”列的名称，我已经强制转换为整数。如果该列具有浮点值，您可以改用 numeric(8, 2)。