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

Get the table count


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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Thu Nov 20, 2014 3:05 am
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
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

Global Moderator


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

PostPosted: Thu Nov 20, 2014 3:44 am
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
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Thu Nov 20, 2014 4:28 am
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

Global Moderator


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

PostPosted: Thu Nov 20, 2014 4:31 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts how to get total count from numeric d... SYNCSORT 9
No new posts Need to read duplicate rows from tabl... DB2 3
No new posts Creating a single-record file with CO... DFSORT/ICETOOL 8
No new posts Identify the count from two diffrent ... DFSORT/ICETOOL 19
No new posts VSAM Open During Copy-Excessive EXCP ... JCL & VSAM 1

Back to Top