DSXchange

Trying to create a sequencer that kicks off 40 jobs. Technically speaking, there is no need for any sort of 'sequence.' All it needs to do is run all 40 jobs at once. What is the best way to accomplish this? FYI, I have brought in all 40 DataStage jobs into the Sequence file, but do not know what to...

I will give it a shot. Thank you!

I am trying to distinguish non-numeric values with alphanumeric ones. For example, if you have the following values:

#
^345
* 999
STRK
STLM
Close*tome

I would want to completely remove '#', have a field contain '345' and ' 999' and a different field with 'STRK' 'STLM' and 'Close*tome'

I am trying to run the following: if alNum(left(trim(<string>),1)=1 and length(trim(<string>)) > 1 then SetNull() Else <string>[2,10] However, it is not working?! Any idea what I am doing incorrectly? I removed everything except AlNum(<string>)=1 then setnull() else <string>[2,10] but that does not ...

Will the field function work? I have the following:

if isnull(Field(lnk_Cast.BASEBALL," ",1)) THEN " " ELSE lnk_Cast.BASEBALL

So if the field does not contain a space, then it will return nothing otherwise it will return the field with the space. Correct?

Can you write an example for this? I was unable to get it to work.

Can anyone provide guidance on creating an equation that will return values if a space exists in the field?

e.g. if you have the following values:

100 hits
strikeout
right field
shortstop

The returned values would be '100 hits' and 'right field'

Is it possible to complete a mass update of stage type objects names for all our DataStage jobs? For example, if we wish to update all the CDC names from different names we currently have listed (e.g. CDC_Q, cdcNow, RT_CDC, etc.) to just CDC. How can we accomplish this versus going into each job and...