DSXchange

That is my understanding as well, but figured I would ask. I don't suppose I could set a link condition to the specific components of a sequence job? So, say I have SequenceA and SequenceB. SequenceA has parts 1, 2, and 3. I then have Sequence_Alphabet that runs SequenceA and SequenceB (lets not wor...

Hi everyone, I have an issue with sequence jobs where we have the notification activity branched off at various points to send a text to us in ETL so we are aware of the nightly running process progression. We have several sequence jobs that run other sequence jobs. Some of these require that the pr...

Marking this as Resolved since IBM confirmed an issue with rollup version in our environment. No idea when it'll get fixed here...

IBM has confirmed the job compiles on their end using 11.5.0.2, working on getting patches installed.

Hmmm wonder if that is it... I was able to trick it to giving me a link from the end loop back to the start loop by removing the end loop stage, adding a new one with no incoming links to it. Linking that to the start loop, which correctly showed the dotted line link. Then re-linking things to the e...

Ok, using the loop stages was my initial plan but I figured I would try doing an infinite. Not a huge deal, set the number of steps to 9999 with 5 second wait times that still 13 hours a loop could run. MORE than enough time. I do have an issue however..... the first loop setup fine and should exit ...

The two sequences used are definitely set to ANY, datastage just doesn't seem to like running a loop back to the same sequence. Essentially it bombs when the process flow follows a path as follows: Sequence Stage, Exec Command, Nested Condition, Exec Command, back to Sequence Stage. This is laid out...

Ok, so tested this again and confirmed it still doesn't work. It appears the job shuts down when the flow goes back to a sequencer that was not exited. Anyone know a functional way to run an infinite loop in a sequence job? DO/WHILE?

Upon further review, sometimes typing things out, reading it, then reading it again in a few minutes helps.... I see that my Or conditions in the code example I gave, should be And conditions.... Index(CheckJobStatus2.$CommandOutput, 'Job Status : RUNNING (0)',1) = 0 And Index(CheckJobStatus2.$Comma...

Hi guys, I have devised what I thought was a method of running an infinite loop in a sequence job. Basically a DO WHILE. I will explain the process in a moment but I went for this method as opposed to using the Loop Activity stages because I wanted the loop to exit on a condition, which those activi...

I suppose the only real way, and ugly way, would be to create a separate parameter set for each parameter. Which would be an abuse of the intended purpose of a parameter set....

Hi everyone, I was wondering if there is a way to use Parameter value files to essentially mimic a dropdown selection for each parameter in a set? Basically I have a list of parameters that I am using as flags. Default value is NO, but I'd like to have a dropdown on each parameter in the set when ru...

Ray that is a great point, one that I have accounted for in a parallel job that does the same thing using a transform stage. I just overlooked that here. To be fair I AM using the MONTH.LAST now instead of what I had originally written. It's definitely more clear in the job what it's doing so we're ...

Oconv(QUARTER.LAST(Oconv(@DATE, "DY[4]") : "Q" : Oconv(@DATE, "DQ")),"D-YMD[4,2,2]")


Interesting.......

Ray, that's interesting... It seems that MONTH.LAST/ConvertMonth() requires the external date string format, and the @DATE/@YEAR/@MONTH variables appear to be in internal format. Thus the only way I could get this to work was as follows: Oconv(MONTH.LAST(Oconv(@DATE, "D-YM[4,2]")),"D-...