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 CLOB Column data to External File usi... lalitmehta12 DB2 4 Tue Aug 21, 2018 7:22 pm
No new posts JCL to send email along with formated... wik123 JCL & VSAM 5 Thu Aug 09, 2018 9:48 am
No new posts Send data from a CICS TS program to M... spiThingy CICS 2 Wed Aug 08, 2018 8:58 am
This topic is locked: you cannot edit posts or make replies. Data Sets are files. Please stop str... jasorn JCL & VSAM 11 Wed Aug 08, 2018 1:55 am
No new posts AFP duplex page containing variable data jose angel santamaria IBM Tools 0 Wed Jul 18, 2018 12:35 pm

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