Number of rows in a data set

abc123 · Post by **abc123** » Tue Dec 12, 2006 4:36 pm

How do I know I many rows are ther in a dataset? I do find it out?

DSguru2B · Post by **DSguru2B** » Tue Dec 12, 2006 4:45 pm

By the command dsrecords mydataset.ds. For more info check this post.

abc123 · Post by **abc123** » Tue Dec 12, 2006 5:08 pm

When I do:
dsrecords mydataset.ds
I get "command not found".

ray.wurlod · Post by **ray.wurlod** » Tue Dec 12, 2006 5:41 pm

It's a DataStage command, so it's in one of the DataStage bin directories.

$APT_ORCHHOME/bin/dsrecords

You can also use the Data Set Management utility in the Manager client.

abc123 · Post by **abc123** » Tue Dec 12, 2006 6:34 pm

ray, thank you for your response. When I do:

$APT_ORCHHOME/bin/dsrecords Myfile.ds

I get the following:

/home/dsadm/Ascential/DataStage/PXEngine/bin/dsrecords: error while loading shared libraries: liborchi686.so: cannot open shared object file: No such file or directory

May be I don't have the library installed?

jhmckeever · Post by **jhmckeever** » Tue Dec 12, 2006 6:55 pm

You need to make sure your $APT_ORCHHOME/lib directory is in your library search path. This path is defined by the environment variable SHLIB_PATH, LIBPATH, or LD_LIBRARY_PATH, depending upon your system.

E.g.

Code: Select all

SHLIB_PATH=$APT_ORCHHOME/lib:$SHLIB_PATH;export SHLIB_PATH

HTH,
J.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 12, 2006 7:18 pm

You didn't execute the dsenv script.

abc123 · Post by **abc123** » Tue Dec 12, 2006 10:22 pm

How do I execute the dsenv script?

I went through the posts in this forum and found some responses. Some of them have lines which probably should be in the environment script but I am not sure. Also, I log in to the UNIX box using my own ID. If I execute the dsenv script, is that going to be for me or for all users?

Thanks.

DSguru2B · Post by **DSguru2B** » Tue Dec 12, 2006 10:28 pm

It will only be for your id for that particular terminal only. Do this

Code: Select all

cd $DSHOME 
. ./dsenv

kumar_s · Post by **kumar_s** » Tue Dec 12, 2006 10:32 pm

Or include this in your .profile so that it can be maintained for all the sessions for that user id. You can prescribe the same for other users as well.

Nageshsunkoji · Post by **Nageshsunkoji** » Wed Dec 13, 2006 11:36 am

If you are not able to do, whatever mentioned by our DSxians....
Just go to the Dataset Management tool in Designer/Manager. Just select your file it will shoe number of rows in each node. Is it ok for you ?

splayer · Post by **splayer** » Wed Dec 13, 2006 1:10 pm

DSGuru2B, I did:

cd $DSHOME
. ./dsenv

Both seemed to have worked. However, I still get the same error. No change at all.

DSguru2B · Post by **DSguru2B** » Wed Dec 13, 2006 1:12 pm

ok then try this

Code: Select all

cd $DSHOME
sh dsenv

abc123 · Post by **abc123** » Wed Dec 13, 2006 1:30 pm

Still the same problem. It is kind of strange. It works for everyone else. I must be missing something.

DSguru2B · Post by **DSguru2B** » Wed Dec 13, 2006 1:45 pm

The id you are using to log into unix, is that the same id you use to log into datastage?