IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

AGGREGATE FUNCTION WHILE UNLOADING DATA


 
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Mon Dec 02, 2013 11:20 pm
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
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

Moderator Emeritus


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

PostPosted: Mon Dec 02, 2013 11:28 pm
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
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 All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts How to find which file contains my se... DFSORT/ICETOOL 6
No new posts Changing Data Type SYNCSORT 4
No new posts Copying data from prev record using SORT SYNCSORT 19
No new posts how to get total count from numeric d... SYNCSORT 9
No new posts DB2 - row_number function - Need 1st ... DB2 5

Back to Top