Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum 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: 19254
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: 19254
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 How to place name of the file where t... danielgp89 DFSORT/ICETOOL 5 Thu Oct 17, 2019 12:55 am
No new posts How to force ISPF to allocate ISPF te... Michele Giannuli TSO/ISPF 9 Thu Sep 12, 2019 2:03 pm
No new posts Need to fetch data from database base... Satandale COBOL Programming 8 Sun Sep 08, 2019 12:01 am
No new posts How to append data from PARM in OUTFIL Poha Eater DFSORT/ICETOOL 17 Thu Aug 22, 2019 4:03 pm
No new posts Training on numeric fields data formats sergeyken SYNCSORT 12 Thu Aug 01, 2019 8:15 pm

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