DSXchange

Investigate the jobs command to determine what background process(es) you have running. Keep executing this till your list is exhausted.

My best two "best practices", apart from "know your metadata" (Ernie's favourite) would be: (1) make sure DataStage developers use only shared table definitions (2) use consistent naming conventions (any one thing has the same name everywhere These will limit the amount of manual...

I have send multiple emails to membership.director@dsxchange.com, editor@dsxchange.net, rick@dsxchange.net, but i didn't get any response. If possible, moderators can you please forward this message to owner. Is there any other means that i can communicate to owner? These are the only email address...

Heck, you don't need any of that fancy stuff. Been over-thinking the problem. Just some plain ol' If..Then.Else constructs will do it easily if there are only the three choices. For example the derivation of Equity would be

To run a command in the background, add an ampersand after the query. To submit the command asynchronously (that is, to make sure that it doesn't die because it can't contact its parent), use the nohup command. For example:

What happens if you submit am IGC query specifying the old type for the parameter?

Actually you could build arbitrary comma-delimited lists in the loop, then expand them if required using a Column Import stage.

We set up an Information Management Centre of Excellence in the Department of Defence (Australia) some eight years back, concentrating on data quality issues and techniques. It is still in operation, gathering to its bosom more and more parts of the Department's information assets.

Could the user variable used by NES_NEW_LINE never be being set to 0?

If you are in an SMP environment, "Entire" partitioning is managed via a single copy in shared memory, so there's no "copy all rows to all nodes" involved. To use a Lookup stage the only restriction is that the reference data must fit in memory. You can time shift building of the...

I have many scenarios where the values files are updated from activities invoked from a controlling sequence before being used in job invoked from the same sequence.

Yes you can. The easiest way is to use a server job that invokes the DSRunJob routine from a Transformer stage.

To help us to diagnose, can you please be specific about how you set up the service in an Information Services Director project? Also please mention what you tried that failed to find the service.

There is not, at least not within DataStage. DataStage jobs run as processes. There may be operating system tools that can restrict the memory demanded by (or supplied to) a particular process, but these are not part of DataStage. Surely the better solution would be to detect the abnormal condition ...

Try entering the experssion as a single line, without linefeeds. If DSLink2.varc1 [14,16] <= ' ' Then 'Msg 1' Else If DSLink2.varc1 [46,9] <= ' ' Then 'Msg 2' Else If DSLink2.varc1 [58,8] <= ' ' Then 'Msg 3' Else 'OK' There is an upper limit on the complexity of a nested If..Then..Else expression, b...