DSXchange

I have created a user defined function. Here is the code in the function WorkFileName = 'wrk':FileName XMLFileName = 'XML.':FileName If OutputDirectoryPath = '' Then OutputDirectoryPath = InputDirectoryPath End If Store = 'XGLOBAL' Then Store='' End MoveCommand = 'mv ':InputDirectoryPath:'/':FileNam...

Can a Data Set or Lookup File Set be read by more than one process at the same time?

I have created an Informational service which has got 2 lookup stages using normal lookup (Not Sparse) involved in it. My question is, is it going to load lookup data in the memory with every request the service receives? or is it going to hold on to the old data that it loaded at the time of the fi...

chulett wrote:The first technical term that comes to mind is... yuck.

I had the same reaction when it came up as a requirement. I just wanted to find out if anyone has any suggestions.

Here is one example <div class='container-fluid custPDPBucketContainer'><div class='row'><div class='col-md-12'><div class='row'><div class='col-md-6'><div class='row custPDPBucketHeader'><div class='col-md-12'> ITEM NUMBER </div></div><div class='row custPDPBucketRow'><div class='col-md-1'></div><d...

I have a requirement to extract data from HTML string. Is there a good/easy way to achieve it using DataStage?

Any suggestion is appreciated.

When we use the built-in functions in Transformer in Server job or Parallel job,
do they get included in the main program after compilation ?

I have same question about the user defined functions.

We are in the process of installing Infosphere 11.5. As a first step we ran ISALite. It produced PrereqChecker-Failures.html. This document has the following messages with "Failed" Status: Ensure that user xmeta can connect to the database xmeta on host infosphere02v at port number 50000 a...

Define "project properties" for us. After logging into DataStage Administrator and choosing a project, we have the option to get to Environment Variable tab. On that tab we have option to Export variables to a file. I am looking for a way to use a command line column which will do the sam...

Is there any command line command available to export project properties to a file ?

I have developed a parallel job where source data is coming from Netezza. I have used Netezza Connector. Records are read in Sequential Mode. The next stage is LookUp Stage where I have partioned the source data using Modulous. Partition scheme for the reference data ( coming through Netezza connect...

No attachment was passed to the web service when invoked from the datastage.

There is no attachment when the SOAPUI request was made. Here is the request. <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/" xmlns:erp="ht...

Yes. this is truly a Server job leveraging the WebService Client stage.

I am invoking an external WebService by using WebService Client Stage. While running the webservice. It is coming back with an error stating 'No Support For attachment'.I checked the WS via soapUI and it works fine. I am getting the following error. TestOracle_UCM4A..Transformer_16: com.ascentialsof...