Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: db2geekami
- Order by date
-
DSNTIAUL truncating COUNT
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...- db2geekami
- Post #2
- Forum: IBM: DB2
-
DSNTIAUL truncating COUNT
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...- db2geekami
- Thread
- Replies: 1
- Forum: IBM: DB2
