DSXchange

Strings when they are compared with each other it happens at the character level i.e character by character comparision, when two strings are of unequal size then is the smaller string padded to make it equal with the longer string, if yes then with which character is it padded with? Ex 'abcd'<'efgh...

Actually (in version 8 and later) DataStage will do this automatically and invisibly. If the same situation arises in versions prior to 8 do we always need to make the other two node in "read only" pool ? and also can you help me with how to do this. I guess this shold me made in the data...

As per my understanding, only the server jobs run with the phantom process what i am not sure is will a grep on 'phantom' capture the running PX jobs?

i am trying to remove duplicates using remove duplicate stage on the emp table using scott user but getting an error like this ... please provide me a work around for it Sequential_File_1,0: Field "COMM" is null but no null export handling is defined I guess you are trying to remove the d...

Thanks for this information. So it is dscs that is at the highest level as far as the client connection activities are concerned and all other services are child processes of this dscs. I have seen in this forums that when ever a request is made for the repository acces the dsapi_slave is forked, si...

Well i was thinking that dsapi_slave is a child process of dsapi_server and when i connect to DataStage using Designer client was expecting to see the process dsapi_server to be running instead i find only dsapi_slave. If dsapi_slave is a child process of dsapi_server is my child process running wit...

The only way this job can be triggered is through the sequence and i was thinking this sequence triggered the job and while it was running the sequence "some how" logged a warning but the job made its way to completion. I am in quest of finding this "somehow". Any other situation...

The warning that was logged for the sequence is "dsqChangeCapture.JobControl (@djsRTRAppFetch1): Controller problem: Error calling DSRunJob(djsRTRCheckConsistent), code=-2 [Job is not in the right state (compiled and not running)]" this was logged @ 02/01/2010 11:25:14 PM but the job djsRT...

I have defined a transform to accept an argument having the dataelement "Month.tag" but when i am actually calling the transform in the transformer stage a column having dataelement "Year.tag" is passed, I was expecting the job to abort as the data elements do not match but it ra...

I have gone through the server job guide but what i am confused is both of them look alike. For example ConvertMonth is a Routine and MONTH.FIRST is a transform surprisingly the code of this transform is nothing but the earlier listed routine 'ConvertMonth(%Arg1%, "F")' . Can any one list ...

I am following the below listed process, Please advice if it is not the best way. 1) read the hashfile with "Pre-Load file to memory=Enabled,Lock for updates" 2) writing to the hashfile with no cache. In the above what kind of lock is applied to the file, is it lock on the entire file or a...

Can any one help me in understanding the two options "Enabled, Lock for Updates" and "Disabled, Lock for Updates" as i did not find the description given in the guide to be friendly.

In the filter stage we can use SQL statements based on which the data is filtered, which flavour of SQL is supported by the filter stage is it IBM DB2 or Oracle or TeraData or is it a not a native of any kind but a mixture of all?

When it is run from the Project Directory it is working fine but loging on to the project using

uvsh "LOGTO dpr_hbus_dev"

from any directory other than project dir it is not working, any help would be greatly appreciated.

Now it seems i made a small Advance. wanted to run "select * from DS_JOBS" 1) Entered into the $DSHOME 2) Sourced the dsenv file 3) Ran $DSHOME/bin/uvsh "select * from DS_JOBS;" Got the result : vhrldct05:/opt/tools/ds/Ascential/DataStage/DSEngine/bin ==> $DSHOME/bin/uvsh "s...