DSXchange

Are you using Join Stage to join both the tables.

If you are using Join Stage then can you check link ordering in Join Stage.
I think link from Table b is doing left join with Table a.

I have not tried mail -x. But, below is the code. I am using to send out mail from unix. #Sending Mail export MAILTO="Receipient Email Address" export SUBJECT="Subject" { print - "From: Sender Name <Sender's Email Address>" print - "To: <${MAILTO}>" print - 'S...

The IBM lady said that the istool is a Python Script in AIX System and Perl Script in Unix Server. And we don't have Python installed on our AIX Server. She is recommending to install Python. So right now I am going to ask my Unix Admin to install Python on the AIX Server. I will keep you guys poste...

That will take care of OR0 as well. Because any how you will eliminating that 0 when you will do Trim(Column_name,"0","L").

Then use the following command. Trim(column_name, "0","L") The above command will get read of all the leading 0's after removing first 3 characters. But, if you have data as KR11000001000001 then it will give you output as 1000001000001. So, you need to make sure that it can neve...

You can try to remove the first 3 character and then trim of left 0's by using Convert function or Replace function.

Is there any pattern for the first few 0's.

For example, Number of 0's before the actual number. Or fixed length of the actual number. Or what is the maximum length of actual number.

Actual number is the number you are trying to extract i.e. 200001, 100001

Sure Craig.
I have opened a PMR. And in the initial talk with the IBM lady she was saying that I might be missing some path in Environment File.

I will keep you guys posted on this.....

Craig, I am in cli directory and it doesn't matter if I put './' in front. I still get the same error. Both the commands are giving me the same error. ksh: ./istool: not found I am going to open a PMR with IBM and see what they have to say. I don't know if I need to install something extra to make t...

Craig,

I am trying to run it from that folder.
It seems that it is looking for Korn Shell.

Ok. There is only one more file out there in that directory. It is setupEnv.sh. And rest all are some directories. -rwxr-xr-x 1 root root 108 Feb 16 2011 setupEnv.sh -rwxr-xr-x 1 root root 560 Feb 16 2011 istool drwxr-xr-x 5 root root 5 Jun 30 2011 features drwxr-xr-x 2 root root 3 Jun 30 2011 links...

What do you mean?
I didn't understand your reply.

When I go to that folder, there is istool file out there. And another file called setupEnv.sh.

Is there anything I can do or just open a ticket with IBM?

Hi, When I am trying to run istool utility from unix box to get an extract. I am getting following error: ./istool: not found I am trying to run the following code. cd /app/IBM/InformationServer/Clients/istools/cli ./istool export -domain serv1:9080 -username usr1 -password pass1 -archive path/TEMP1...

Use the following code in User Variable Activity will get all the email address in the Email_List User Variable UserVariables_Activity_89 Email_List : Field(Convert(@FM, "", ExecCommand.$CommandOutput),'',1) And then in the Mail Notification activity in the Recipient Email Address write th...