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
 
Get the table count

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

New User


Joined: 26 Sep 2008
Posts: 12
Location: Bangalore

PostPosted: Thu Nov 20, 2014 3:01 am    Post subject: Get the table count
Reply with quote

Hi,

Is it possible to write the count of records in a db2 table into a file using DFSORT or ICETOOL?

Thanks,
Suja
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Thu Nov 20, 2014 3:05 am    Post subject: Reply to: Get the table count
Reply with quote

Well, how about you look up DB2 in the DFSORT Application Programming Guide?
Back to top
View user's profile Send private message
Suja.Sai

New User


Joined: 26 Sep 2008
Posts: 12
Location: Bangalore

PostPosted: Thu Nov 20, 2014 3:22 am    Post subject:
Reply with quote

Hi,

Checked it.... but couldn't find the solution.

Thanks,
Suja
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2064
Location: NY,USA

PostPosted: Thu Nov 20, 2014 3:44 am    Post subject:
Reply with quote

Suja, why would you want DFSORT/ICETOOL to do it? You already have a unload utility so simply you need to write the count(*) query. However if you have the load file then you could get it with Sorts.

And to answer your original question, I am not sure if that can be done.
Back to top
View user's profile Send private message
Suja.Sai

New User


Joined: 26 Sep 2008
Posts: 12
Location: Bangalore

PostPosted: Thu Nov 20, 2014 4:00 am    Post subject:
Reply with quote

Hi Rohit,

Thanks for the reply. I have tried the unload utility count * option. Just wanted to know if the same can be done using DFSORT/ICETOOL.

Thanks,
Suja
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Thu Nov 20, 2014 4:28 am    Post subject: Reply to: Get the table count
Reply with quote

Yes, the point of looking in the manual and finding no way to manipulate DB2 tables was to indicate a quick way of checking whether it was possible. Quicker than posting here :-)
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2064
Location: NY,USA

PostPosted: Thu Nov 20, 2014 4:31 am    Post subject:
Reply with quote

Bill, Just Wow icon_biggrin.gif !!
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 To get the count of PDS data sets whi... Vignesh Sid JCL & VSAM 4 Fri Nov 30, 2018 8:38 pm
No new posts What is a table space in db2 for z/os? martin schlatter DB2 13 Sat Nov 24, 2018 11:19 pm
No new posts How to count the number of times key ... vnktrrd DFSORT/ICETOOL 14 Thu Nov 15, 2018 9:19 pm
No new posts Modify the value of a extensionvariab... UmeySan CLIST & REXX 29 Wed Nov 14, 2018 11:48 pm
No new posts Merge two files and sum up the count ... preeti6 JCL & VSAM 6 Thu Sep 06, 2018 10:57 am

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