DSXchange

There is no equivalent single function. Mathematically you could use integer division and modulo in a transform stage to convert (good only for smaller values, since it would need to be iterative for larger value conversions), but it might make more sense to call a cpp function to do this.

That would be the Terminal Command Language or the ">" prompt and environment from DataStage/UniVerse. This is what you see when you enter the dssh or execute commands from the Admin tool.

Please give an example of what you consider a "special character", with both the symbol and the numeric character value. Strings can contain any character and have no inherent restrictions, you just need to declare the correct character set in order for the string contents to be correctly ...

The DaysSinceFromDate() function gives you the difference in days between your two dates. The WeekdayFromDate() function returns the weekday number. Then use the days difference and day-of-week to compute valid dates.

Craig - I knew what you meant, but thought I'd expand on your terse answer this time

Please post what you have tried, then someone might be able to make suggestions.

The PX version is a set of extensions to Server; i.e. it contains the server version. Thus, if you are installing 7.5 PX on a 7.5 Server machine you don't need to run separate instances or de-install PX; you would just stop using the PX portion of the product.

How sporadic is the error? Can you identify any scenario on the system which, even if unrelated, might be triggering this problem?

Try using Does the output look different? Is the length of CmdOutput greater than 0?

The left() and right() functions, as well as the In.String[startpos,length] syntax work identically in server and parallel transform stages.

Do you have autopurge set for this job? If yes, try turning it off and and seeing if the error is reproducible. I recall that there have been some odd errors involving multiinstance jobs and the autopurge partially deleting entries and causing some mayhem. I don't know if this applies in your case, ...

Could you could post your SQL join?

it is an undocumented internal function which add data to the memory structure.

Use a transform stage and 2 stage variables to store eid and ename, then a constraint for row type 3 to output all 3 values together. This assumes the row order is always 1,2,3,1,2,3,1...

That is strange indeed, as everything looks OK. What output do you get with "dsjob -lprojects"? Just the "dssqa" project?