Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
AGGREGATE FUNCTION WHILE UNLOADING DATA

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ravi.singh

New User


Joined: 05 Oct 2013
Posts: 18
Location: india

PostPosted: Mon Dec 02, 2013 11:07 pm    Post subject: AGGREGATE FUNCTION WHILE UNLOADING DATA
Reply with quote

Hi Sir,
While using the SUM function in my unload query the file length is increasing ,while the same query,If i am not using SUM function .Th file length is coming as expected .Please guide what to do

Please note there isn't any problem with the size i.e there are only two rows satisfying the query and sum is coming as 1033.56
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Dec 02, 2013 11:20 pm    Post subject:
Reply with quote

Hello,

You have not provided much that can be used to help you . . .

Is there something particularly interesting about 1033.56?

You have not said what size is being generated or what size you want/expect.

Suggest you post the jcl and control statements as well as the informational output created by the run.
Back to top
View user's profile Send private message
ravi.singh

New User


Joined: 05 Oct 2013
Posts: 18
Location: india

PostPosted: Mon Dec 02, 2013 11:24 pm    Post subject: Reply to: AGGREGATE FUNCTION WHILE UNLOADING DATA
Reply with quote

Hi,
Thanks ,I can understand ,I haven't provided any Data ,i will give data and will ask question again.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Dec 02, 2013 11:28 pm    Post subject:
Reply with quote

Ok, someone will be here . . .

d
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Dec 03, 2013 1:19 pm    Post subject:
Reply with quote

Any questions about what format/length comes out of a particular unload can be solved by looking in the generated SYSPUNCH (if it is not set to dummy).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts 3270 Data stream error Benchwarmer CICS 6 Tue Apr 17, 2018 12:06 am
No new posts How to list data set names with diffe... murali.andaluri CLIST & REXX 8 Thu Apr 12, 2018 11:33 pm
No new posts Invalid XML character while producing... nikhil.bhole IBM Tools 4 Tue Mar 20, 2018 1:24 am
No new posts Get the list of data sets on DASD and... rakaitn JCL & VSAM 3 Thu Mar 08, 2018 12:38 pm
No new posts Unloading DB2 table in CSV format alo... grvtomar COBOL Programming 7 Sun Jan 28, 2018 2:05 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us