DSXchange

Hi, I have a situation where I am looking up days between Target Date and Task Complete date. In the transformer I am looking up workdays and holidays in between. I need to pass the Target Date and Task Complete date and it returns the number of workdays or holidays. Now the issue is that even thoug...

recompiling doesn't provide more error information (the complete address never displays in the log). The transform just loads data to the sequential file, and generates an extra column called AGGREG_DATE using the following input Oconv(DATE(),"DYMD[4,2,2]"):" ": Oconv(TIME(),&quo...

nothing that I'm aware of in the week since this datastage job last ran. I will confirm with unix support as to whether they have done anything to the unix server tomorrow though (usually they post around notification if they do though). Curiously, about 5 hours after attempting to re-run this job, ...

Hi there, I've been reading the forum regarding error of "Fault type is 11", and tried out some of the solutions such as altering the buffer and timeout figures, ensuring the job doesn't aort after a single warning, and killing off phantoms. My job still aborts when I try to run, and gives...

Hi,

Is Datastage 8 for Solaris Unix out yet?

I thought those datastage api functions are supposed to be DLL imported so the compiler shouldn't be trying to link those functions.

Did anyone get this to work, ever?

Hi,
Anyone one else ever came across this link error before?

Hi, If I redistribute in English speaking countries, vmdsapiENU.dll will do, right? Also, do I just need to place the dlls (DSCLNT32.DLL, dsrpc32.dll and vmdsapi.dll) in the same directory as the compiled executable? I suspect I'm not putting them in the right place as I'm getting the following link...

Hi, in the document it says: If you want to run the application from a computer used as a DataStage client, you should redistribute the following library with your application: vmdsapi.dll This file refers to the 'C:\Program Files\Ascential\DataStage7.5.1\vmdsapiENU.dll" right? Also, we run ser...

I just went to www.ibm.com and did a search on "DataStage SOA" and got several references to red books, pdf files and other documents. The first big hit is This page Hi, that all seem like it's for Datastage 8. Has anyone ever used SOA in Datastage 7.5. If so, any comments regarding the S...

chulett wrote:No, it means you need to look into issuing 'remote shell' commands.

And yes, DataStage has support for SOA, like web services, etc.

Hi, where can I find more information on DstaStage's SOA support, is it a plug-in we need to buy? Where can I find to documentation/white paper for it?

ArndW wrote:The command line program dsjob lets jobs be started on a remote system, the syntax is dsjob -server {name} -user {name} -password {name} -run -mode NORMAL {project} {job}[/b]

That means I'll need to copy the dsjob program to the 'a1' server right? Where is dsjob located?

Hi, Can datastage jobs be triggered by events from another server? Say I have a transaction on server 'a1', and after that transaction completes, I want to run a datastage job on the server 'a2'. Is that doable? Also does datastage have any support for service oriented architecture, like web service...

Thank you very much you've answered my question.

If I want users to constantly be able to query the table I need to use the delete, rather than truncate function.

Cheers.

Using DataStage Server Edition, oracle OCI Stage When selecting how to update a table there are two options I'm interested in. Clear table then insert rows and Truncate table then insert rows. I know the difference between the delete and truncate functions, but what I would like to know is how DataS...