How to count he number of records in a dataset

[kool78]

Any ideas on how to get eh count of number of records for a dataset.

i tried to look for the 'orchadmin' commands but didnt find any help.

thanks

[vijayrc]

Any ideas on how to get eh count of number of records for a dataset.

i tried to look for the 'orchadmin' commands but didnt find any help.

thanks

Manager/DataSet Management.....

[kool78]

Any ideas on how to get eh count of number of records for a dataset.

i tried to look for the 'orchadmin' commands but didnt find any help.

thanks

Manager/DataSet Management.....

is there any other way...i know we can get the count from dataset manager/managment.

i want to use it in my process..like if records exist then proceed else not.

[Teej]

I am not too familiar with how "orchadmin" is ported to the Windows platform (most likely using the wrapper). It is located within PXEngine/bin subdirectory within DataStage's directory.

If it was on the UNIX box, it would be a very simple task of using a command stage within a sequencer job to call orchadmin with the relevant options (you can find out the available options running it without any options).

Give it a try, and remember -- you need to be on the DataStage SERVER not your own client.

[ag_ram]

This is the sample code.

Code: Select all

export DSHOME = '/appl/infoserver/Server/DSEngine'
export APT_CONFIG_FILE = '/appl/infoserver/Server/Configurations/2node.apt'
export APT_ORCHHOME = '/appl/infoserver/Server/PXEngine'
export PATH = '%PATH%' : '/appl/infoserver/Server/PXEngine/bin'
export ORCHBIN = APT_ORCHHOME : '/bin'
export LIBPATH = '/appl/infoserver/Server/PXEngine/lib'

[b]dsrecords DSdir/datasetFilename.ds[/b]

You can catch the return code which is the count of records in dataset.

[umamahes]

dsrecords <datasetname>

Thanks

[kool78]

dsrecords <datasetname>

Thanks

thanks for the response, seems to be working.. it displays the out put as ex: 1500 records

can we omit the later part i,e' records' and allow it to display only the value like 1500.

[jhmckeever]

Hi kool78,

Off the top of my head, I think the following should work ...

Code: Select all

for /f "tokens=1" %a in ('dsrecords YOURFILE') do echo %a

... where YOURFILE is your dataset descriptor file.

HTH,
John.

[ray.wurlod]

can we omit the later part i,e' records' and allow it to display only the value like 1500.

Use the -n option of the dsrecords command.

Code: Select all

dsrecords -n /app/Ascential/DataStage/Projects/MyProject/Controls/MyDataSet.ds

Best Practice Tip
Create a directory in your project in which all descriptor files for Data Sets, Lookup File Sets and File Sets are kept and make the pathname of that directory a job parameter.

[kool78]

can we omit the later part i,e' records' and allow it to display only the value like 1500.

Use the -n option of the dsrecords command.

Code: Select all

dsrecords -n /app/A ...[/quote]

thanks ray,

followed the dsrecords method,


dsrecords -n <datasetname>