DSXchange

Hi All We have a pull job that we want to get invokved FROM BW But even though thejob is defined as pull job when BW invokes it we see it coming to datastage as seen in the log under the path below but the job does not get invokved. $ pwd /usr/IBM/InformationServer/Server/DSBWConnections/SAPBWD/Sour...

Thanks a lot for the reply Convert(@FM,"",Command_To_Chk_Rejects.$CommandOutput) > 0 solution works I will try and understand what it does but it seems to work The other solution Command_To_Chk_Rejects.$CommandOutput[1] > 0 does not seem to work Thanks a lot again and I will consider this ...

The point is that it goes through to execute the notification stage when my output is 0 and I am telling it to send email only if the value is greater than 0

Sigma

Hi The output of my log for the execute command stage is Seq_Madison_Customer_Master..JobControl (@Command_To_Chk_Rejects): Executed: wc -l /cdwdata/reject/pharma/madison/*Rejects.txt | grep total | awk '{print $1}' Reply=0 Output from command ====> 0 Then I do a custom expression in the next check ...

So out of the box if it expects lastname, firstname then I will have to format my data to confirm to meet the lastname comma firstname. That means we have to know how to parse and identify lastname and firstname and that defeats the purpose of the tool if we have to know so much details about the da...

Hi All We are a AIX environment and using datastage and quality stage. We are learning to use standardization within quality stage and have a lot of questions. We are hoping to get some help from this forum. Thanks in advance for your help. We are trying a much simpler example to explain as all the ...

Hi I have the following command and the output of it is 3 (as there are 3 lines in the file) $ wc -l *Rejects.txt | grep total | awk '{print $1}' 3 $ But when I use the above command in the execute command stage I get the following Sequence job output Process_Customer_Master..JobControl (@Command_To...

We are setting up a new instance of the datastage and we are rather new to the product here in Sigma We have a question about the directories where we can create the hash files, datasets sequential files. Is it a recommended practice not to have that directory under the Project directory. For exampl...

IBM support helped us out with this issue Apparently there are some core libraries that needs to be present for AIX version and those were missing. We have install those library files first before running the install. In other words this was a case of not installing properly Thanks to all who took t...

Hi <B>On our development server (datacld) </B> Server software version 8.0.1 Fix Pack 1a Client also has the client software and Fix Pack 1a The SAP BW client (4.3.1) and SAP R3 client (6.0) are installed on the client ( which is on a citrix host) We are able to use the SAP packs just fine <B>On our...

We have email addresses in a Customer Contact name field, if the prep rule set does not parse this specific data value do we customize the rule set to do so to meet our needs

What is the difference between drop current token and drop all remaining tokens in the Override Rules Input Patten?

We need to standardize for countries worldwide such as Poland, Russia & Portugal, the only countries available in Datastage is:-

Australia
Canada
France
Germany
Italy
Japan
Korea & Spain

How do we address this?

Can someone explain to me the difference between a Match Set and a Match Pair when I view my specification results please?

Hi We created a copy of the COUNTRY rule set in our development environment but when we try to delete the copy it gives this message These objects are not referenced by any other objects We were able to delete the copied RULESET but not these objects of the RULESET. We get the following message when...