INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

DSNTIAUL truncating COUNT

DSNTIAUL truncating COUNT

(OP)
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      
ORDER BY WKS_DUR, TOTAL_WBA DESC
WITH UR; [code]

DSNTIAUL creates a sequential file with data fields for each column of data returned. The fields are automatically defined as half word binary (PIC S9(4) COMP). This limits the largest number that can be stored to 65,535. One record has a count that exceeds that value and is being truncated.

Is there a way to expand the size of data fields created by the DSNTIAUL utility? I've tried CAST with INTEGER but it still creates the data fields as half word binary.  

RE: DSNTIAUL truncating COUNT

(OP)

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,               
//            DISP=(,CATLG,DELETE),                
//            UNIT=DISK,SPACE=(TRK,(5,1),RLSE)
//* OMIT THE DCB PARAMETER     
//* LET THE UTILITY PROGRAM DETERMINE RECORD LENGTH  
//* AND DATA FIELD DEFINITIONS
//*    

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close