DSXchange

What's interesting is, in the log it says "Output from command ====>
2" for the ExecCommand activity which means it is returning the right value. It is just during the addition or in the Job Activity stage that the value is getting lost.

ray thank you for your response.

Actually I have the $ and I am picking from the Acitivity Variable pop-up. I am not typing it in.

It doesn't give the expected value. In the parameters of the JobActivity stage, I am doing ExecCommand.CommandOutput + 1.
This value should be the parameter value in the job of the JobActivity stage. I always get a 1. I tried ReturnValue as well. If I change the 1 to a 3, I get a 3.

I have a sequencer loop where I have an ExecCommand followed by a JobActivity stage. In the ExecCommand, I am calling an UNIX command, cat filename, which has a value. I would like to do ExecCommand.CommandOutput to get this value, add 1 to it and use that value as one of the paramters of the job in...

Ok. I found the solution. My script did not have a return at the end which was causing this.

ray, I put the following in the Input Value:

ksh scriptname.ksh parameter1

I don't get any error but it doesn't do what it is supposed to do. However, when I copy the string from Director and execute it, it works fine. Any ideas?

Yes, the same id.

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

I have a job activity in a sequencer. I would like to run an after-job subroutine for the job. I am going to use the ExecSh command to run a shell script. A parameter needs to be passed to the shell script. Will I be able to do something like: execSH("ksh MyShell.ksh Prm1")? How do I pass ...

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 ...

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 libr...

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

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

Korn Shell, Perl, Bash or others ? As a DS developer working in a UNIX/LINUX environment, knowing a scripting language helps enormously. I would like to hear your opinions as to which one might be best for a long term DS career.

Thanks.

The number of rows going from the Copy To Sample shows 100.
Here are the Sample stage properties:

Max Rows (Per Partition) = 10
Period (Per Partition) = 1
Sample Mode = Period