DSXchange

That's another 'classic' solution.

Welcome aboard. :!: I cleaned up your examples using ' ' tags to preserve the whitespace you need so the columns line up. By default the forum software removes all 'extra' whitespace from a post. FYI. That being said, I don't see a need for any looping or grouping - this looks like a classic 'fork j...

Sweet! Thanks for the clarification, I would have thought having it at the job level would have been fine as well. Good to know.

Permissions?

ps. Here is the TechNote for the issue and APT environment variable in question.

Try if A <> 0.00 Not equal? All that tells you that the value is not zero with no clue as to the sign. Ankush - I'm hard pressed to believe that this product would consider 0.068 as being less than zero since (as you noted) it certainly is not. Can you show us the actual syntax you are using and th...

What are you considering to be "GMT format"? GMT stands for Greenwich Mean Time and it's a time zone not a "format"... so a little confused as to what you need right now. What does the "D" represent in your seven character format string?

1. Been discussed quite a bit, an exact search for "call dssetuserstatus" should turn up the pertinent ones.

2. Call it regardless and set it to 'Y' or 'N' as appropriate and then check in your trigger.

No, you did what I asked. To me it seems that even with the APT parameter added your single quotes are still being stripped. At this point I would involve your official support provider.

I understood clearly it is because of the special meaning for the characters like +,|,% etc Datastage have!! Those characters have no "special meaning" to DataStage, that SQL would be passed to the database and run there as any other client tool would. As noted, the only "special&quo...

Seems like another place where setting I added this variable with the value 1 for all the runs. Still no luck. Its only purpose is to stop single quotes from being stripped from the parameter value. It wasn't mentioned as a solution to the larger problem of all of the overzealous escaping. :wink:

Parameters don't work that way - they are used to pass data into a job. When you pass in function names (as you've seen) they just become strings of data as there isn't a second level of 'resolution'. It is the same reason a parameter cannot reference another parameter. Off the top of my head, you'l...

Was going to get to the 'LastRowInGroup' part as something needs to push out the last 'group' when taking this approach but wanted to check the version you are running as it was included starting with 8.5.

when I try to run it on single node the results are completely different. Then your logic is flawed. You'd need to supply the details of your job design to allow anyone to help without continuing to guess at this point. What field(s) did you specify as the change keys in the Sort stage? Is the KeyC...

Again, you cannot specify a Windows code page on a UNIX server.