DSXchange

That's one question we've been trying to answer. The way this works seems to have fundamentally changed in 7.5. In the past, all of the leftover "sendmail_xxxxx.sh" files sat around in your Project directory forever and gave you something to look at. Now, the file is deleted after the process finish...

Funny... me. too. 7.5 on HP/UX 11i.

What version of DataStage? 7.5? What OS?

I'm having the exact same issue, but only on my test box where I'm running 7.5, not anywhere ever before on an older version. I have an open support ticket with Ascential and we're trying to track down the cause.

Glad you found it helpful, Richard. There's always more than one way to skin the DataStage cat, so in addition to what Ray suggested, something else to check out - the UserStatus area. It is an area each job has where a single piece of data can be written and retrieved at any time after the job comp...

Just out of curiousity - what flavor of 7 did you upgrade to... 7 dot what?

That's usually a permissions issue - make sure your ftp user has what it needs to overwrite as well as create target files.

Don't use link name in the sort spec, simply specify the column names.

Yup, the Aggregator is one answer when your data isn't coming in sorted.

For testing? I'd go the route that Siva mentioned - simply make use of the ability of DataStage to stop processing after a certain number of rows have come into the job. That way there's nothing to remember to "undo" before it goes into production.

Ahhh, Richard... let's tawk. First, just about stage variables in general. They've been quite the boon since they were added to DataStage as they've got a ton of uses other than in the context you are concerned with right now. A couple of examples off the top of my head: *For repeated derivations. W...

Both of these require a VOC record pointer to work, correct? I know the syntax is here somewhere (SET?) for those who work exclusively with pathed hashes...

Hmmm, someone seems to have "unreplied" to this. Be happy to help with Stage Variables and detecting changes in repeating groups if there is a need...

See if this post helps.

Courtesy of KBA: TCL = 'SSELECT DS_JOBS' If JobNameSubstringMatch Then TCL:= ' LIKE "...':JobNameSubstringMatch:'..."' If Folder Then TCL:= ' WITH F3 = "':Folder:'"' Call DSExecute("TCL", TCL, ScreenOutput, SystemReturnCode) Call DSLogInfo("TCL Output f...

The only reason I asked about the number of runs option was, in my case, it would take while the other would not. If I set that particular option first, then for some reason I could change it from runs to days and that would also stick... but I couldn't set it directly. I've got a utility that will ...