Hi
We need to read a dataset and get the number of records in it and write it into a file
Is there function or system routine or some command which will help me achieve this.
Thanks in advance
Record Counts from Data Set
Moderators: chulett, rschirm, roy
Hi
Is this "orchadmin describe -d -l <your dataset file> " is what I use in a transformer ?
We want to have this is some job like we will pass a list of datastets to it and we need to put dataset name and the record count in each into a file with two columns FileName and RecordCount.
from the link you gave looks like orchadmin describe -d -l <your dataset file> works but please advise me how to use it.
Thanks
Is this "orchadmin describe -d -l <your dataset file> " is what I use in a transformer ?
We want to have this is some job like we will pass a list of datastets to it and we need to put dataset name and the record count in each into a file with two columns FileName and RecordCount.
from the link you gave looks like orchadmin describe -d -l <your dataset file> works but please advise me how to use it.
Thanks
-
AmeyJoshi14
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Hi,
You can use shell Script....
In that you can make use of "dsrecords" commmand to get the record count of Datasets..
dsrecords -n Datasetname
You can use shell Script....
In that you can make use of "dsrecords" commmand to get the record count of Datasets..
dsrecords -n Datasetname
http://findingjobsindatastage.blogspot.com/
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)