Omit the DCB parameter from the JCL for the output data set. Let the DSNTIAUL utility program determine the length of the data extracted from DB2. When the value of COUNT exceeds 65,535, the data field will be defined as a full word binary [PIC S9(8) COMP].
//SYSREC00 DD DSN=AA4717.DB2.UCCLMS...
I am using DSNTIAUL to unload data from a DB2 table. I count the number of distinct SSN's as well as return two other columns of data.
[code]
SELECT COUNT(DISTINCT SSN),WKS_DUR, TOTAL_WBA
FROM UIPROD.UCCLMS
WHERE YEAR(BYB_DTE) = 2010
GROUP BY WKS_DUR, TOTAL_WBA...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.