Unanswered: Dsntiaul - cast as decimal renders extraneous trailing low-value
I am using the DSNTIAUL utility (with the PARM 'SQL' feature)
to create a formatted flat file from a DB2 table. I am trying to prevent a CAST AS DECIMAL statement,
from rendering an unwanted extraneous trailing low-value that follows the result.
For example, this statement :
SELECT CAST (ANNUAL_SALARY/24 AS DECIMAL(11,2)),
CAST ('12' AS CHAR(02)) FROM TEST_TABLE;
will result in an extraneous low-value byte that separates the ANNUAL_SALARY/24 result from the "12" literal.
I do not want that separating low-value.
Oddly enough, if I do "not" perform a division operation i.e. CAST (ANNUAL_SALARY AS DECIMAL(11,2))
the extraneous trailing low-value byte dissappears.
I have tried many variations (substringing, etc.) and I cannot get rid of the low-value.
I may have to pass the file to a subsequent utility step to get rid of it; but I am trying to
I would be very greatful if anyone has advice on how to remove the extraneous trailing low-value.