DSXchange

ray.wurlod wrote:How would you do this without DataStage? You use precisely the same means when DataStage is in the mix. ...

Hi Ray,

I just wanted to know how to implement it using DataStage?


Thanks
Santosh

Hi All, I have a requirement to FTP a set of csv files from SFTP server to DataStage server. Requirement detail is below- When DataStage job lunched- 1) DataStage job should check for complete set of csv file. Each set of files will be named with prefix of 'YYYYMMDD_ as follow a)YYYYMMDD_file1 b)YYY...

Hi All,

Could any body tell me the majot differences between DataStage 7.5 and 8.2


Thanks, Santosh

Hi All,

I have requirement to fetch Data from "EV4 data files" using DataStage 8.0 Server job?

Can we do this unsing DataStage?

Thanks in advance.

-Santosh

ray.wurlod wrote:Perhaps you misspelled the URL. After all, you misspelled "Ernie". Some people are offended by that. ...

I am very sorry for that.

But I am hitting the right URL and not getting the sample dsx over there.

It can be done...but requires some extra work. The WSPack cannot directly handle an array...so you will ultimately need to place xml stages around your WS Transformer. Take a look at this link where I describe it and include a .dsx : http://dsrealtime.wordpress.com/2008/05/16/calling-a-web-service-...

The error is datastage does not allow me to set partioning in the transformer inputs page. For any partioning which we set it pops up a message ==== "Unknown Name" . This is only in transformer and it is not a compilation error. For other stages the partitioning works fine.... Please help ...

Hi, I have a requirement to consume web service operation using datastage job. I know we can use Web service pack for consuming web service. My requirement is to pass the input in form of array so that while calling web service operation It would make single call to webservice with as single input c...

Hi All, I am using web service pack in DataStage job. I am using web service transformer stage to send request to web portal and store return in a sequential file. My job design is like this- Source DRS-->Transformer-->web service transformer stage-->transformer---->sequential file. But while runnin...

Hi,

Can we have multiple configuration files for a datastage job.

Thanks

Hi All, I am working on one POC for Publishing DataStage job as web srvice. I tried searching some help regarding this in this forum and came to know that by using WISD input and WISD output stage we can implement this. But I do not have any idea how use WISD input and WISD output stages, how to des...

Hi,

Can we expose datastage job as webservice?
I mean can we publish DataStage Jobs as web service.

Thanks
Santosh

Hi All, Using execute command activity stage in datastage, i reading a text file which contain the record count. The out put this stage is being treated as string in DataStage while text file contains no only. Is there any function in DataStage to convert string to numeric value. For exp- my text co...

Pagadrai wrote:Hi Santosh
What is your source ?
Is it possible for you to get the count of source records before you call the DS job?

Hi my source is Oracle. We can get count of record before every run.

Hi Santosh, I think u should use the logon clause along with the dsjob command. "DataStage CLI connects to the DataStage server engine on the local system using the user name and password of the user invoking the command. You can specify a different server, user name, or password using the log...