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 Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am

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