The current Help says "scale ... The default setting is 6." That is not always true. The Help should say this instead: "scale ... If precision and scale are both omitted, the default scale is 6. If precision is specified but scale is omitted, the default scale is 0." BEGIN DECLARE x DECIMAL ( 20 ); DECLARE y DECIMAL ( 20, 0 ); DECLARE z DECIMAL; DECLARE a DECIMAL ( 30 ); SELECT EXPRTYPE ( 'SELECT x', 1 ), EXPRTYPE ( 'SELECT y', 1 ), EXPRTYPE ( 'SELECT z', 1 ), EXPRTYPE ( 'SELECT a', 1 ); END; EXPRTYPE('SELECT x',1),EXPRTYPE('SELECT y',1),EXPRTYPE('SELECT z',1),EXPRTYPE('SELECT a',1) decimal(20,0),decimal(20,0),decimal(30,6),decimal(30,0) asked 03 Apr '20, 15:15 Breck Carter |
...and now the help does tell so (at least within DCX):
Thank you, Volker (and jbschueler!) ...I'm sure it'll appear in the SAP Help Portal real soon :)
I really appreciate the German-labelled stamps... Bürokratie rocks:)