DSXchange

You can also use UserVariables activity instead of Routine Activity stage.You can achieve the same logic and shouldn't receive any warnings

we loaded data into a sequential file from oracle, and then loaded to DB2 using the ODBC.......i dono if this makes any difference.

Ray,
We loaded the Data to DB2 from oracle using ODBC stage. Now the same data is being read through the ODBC stage as lookup. ......if it is a Unicode issue, it should have happened during the load to Db2 itsself ......not when using the data as lookup right???

I am getting the following error when i run the job. Job is to read from oracle, lookup with a DB2 stage load it to a oracle table & hash file. The query below is from DB2 stage, when i do a view data and start search for the data, i am getting the same error Did any one come accross this error?...

I am aware the hawk version is not yet released. I have seen few queries on hawk beta version in this forum. so, i was expecting a "readme" file. if any one has......

Can any one send the release note for the Hawk version ??? if so, please send it to vcannadevula@yahoo.com

Well, it was a heck of a story .......... Datastage license is still valid. We have opened a ascential ticket regarding this. .......OOPS this might be the biggest mistake i have done. On further investigation by running the "netstat -a | grep ds" nothing was running. But when i run "...

The error messages look like log entries for an Oracle job and normally have nothing to do with the engine itself. What command did you issue that generated that output? I tried restarting the datastage by bin/uv -admin -start I started getting this above message. Datastage is not starting Even whe...

Is there any change in data? What is the data type been used? I once faced the problem with the APT_PADCHAR property. The file produced by another job was with different padchar and hence messed up. There are some unicode feilds in one input to join on which I am joining the data ,before the join s...

Currently we are in datastage(V6.0.1)support project. we are going to Migrate it to V7.5.2.we are using both windows and Unix.(only server jobs are using) So, 1.How to start migration from one version to another version? 2.generally what kind of problems will come ? 3.Are we need to compile all the...

What kind of stage is it, and to what kinds of stages does it connect? Without that information your question is in the "my car doesn't work, what's wrong with it?" category. The abort is happening on Transformer stage. source is a hash file and target is a flat file. Between the transfor...

The (-14) [Timed out while waiting for an event] issue is quite common and has been discussed for years here. It's something to be "managed", but not resolved, from what I have seen. Just yesterday Arnd talked about a custom patch written for his specific customer to extend the timeout va...

Just an additional Info This is the log from previous run when i reset the jobs for the Abnormal termination of stage. From previous run DataStage Job 1607 Phantom 791 Job Aborted after 1 errors logged. Program "DSD.WriteLog": Line 201, Abort. Attempting to Cleanup after ABORT raised in st...

We are getting the following message and some of the jobs are being aborted by giving one of the below warnings Abnormal termination of stage LdPgmRlsGmew.6575.xLoad detected Job Aborted after 1 errors logged. Attempting to Cleanup after ABORT raised in stage LdPgmRlsGmew.6575 Job control process (p...

I got certified in Datastage today. It was challenging experiance. Finally i pulled it off.


Thanks for the blob, vmcburney. It was very useful for the certification