Data Set record count (not orchadmin)

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Data Set record count (not orchadmin)

Post by PhilHibbs »

An IBM chap recently told me that there is a utility that retrieves the record count from a .ds Data Set - not orchadmin but some other utility. Any ideas what he was referring to? I can't remember!

I can get the info from orchadmin, I can do "lf -d" and parse the text output looking for "records : " but if there's a utility that just gets the record count then that would be better.
Phil Hibbs | Capgemini
Technical Consultant
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Re: Data Set record count (not orchadmin)

Post by PhilHibbs »

Just as I hit "Submit", a solution occurred to me - have a look in the PXEngine/bin directory and see if anything rings a bell! The answer is: dsrecords.
Phil Hibbs | Capgemini
Technical Consultant
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

Re: Data Set record count (not orchadmin)

Post by zulfi123786 »

PhilHibbs wrote:Just as I hit "Submit", a solution occurred to me - have a look in the PXEngine/bin directory and see if anything rings a bell! The answer is: dsrecords.
to be more specific:

Code: Select all

dsrecords -n 
as documented in the Ochestrate guide
- Zulfi
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Re: Data Set record count (not orchadmin)

Post by PhilHibbs »

zulfi123786 wrote:...as documented in the Ochestrate guide
There's an Orchestrate guide? I found some info in the Advanced Parallel Job Developer's Guide, and once I knew the answer I did find dsrecords documented in there, do you mean that?
Phil Hibbs | Capgemini
Technical Consultant
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Well... there is an actual "Orchestrate Guide" but according to Ray you have to request it from your support provider.
-craig

"You can never have too many knives" -- Logan Nine Fingers
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

Post by zulfi123786 »

Which version of advanced parallel job guide are you referring. I don't recollect having read about dsrecords in version 7.5 however dsrecords is documented in orchestrate users guide
- Zulfi
Post Reply