DSXchange

I believe true brilliance is to simplify a complex problem so anyone can understand it. Fake intelligence is to make something artificially complex. Some consultants make processes so complex that customers are afraid to get rid of them. Fear and manipulation are powerful tools used by consultants a...

Just to illustrate my point. As the number links in a job goes up the complexity goes up disproportionally. C + * o + * m + * p + * l + * e + * x + * i + * t + * y + * + * + * ++++++++++++++++++++++++++++++++ 0 50 100 Number of Links in a job The same is true for man hours to build these jobs. At so...

I do not know DB2 but in Oracle you can create functions. ODBC and plugins treat these like columns. In Oracle I do not think you can do an update or insert but if you could then a function could work like Nextval. This can be used in a user defined insert where the key is replaced by the Oracle seq...

It is still ugly.

Rainman was the older brother.

Craig, you talking to me or Ray?

I would not do this in BASIC. I would do it in a function if you can update in a function. You could do it like they do a sequence number in Oracle.

Tell them Ray man.

What version of DataStage because this works fine in Ds7.1 and above.

I say separate small sequences with only dependent jobs in one sequences. Say you have customer snowfalked off of order then order would need to follow customer then I would put these in the same sequence to control the jobs.

It should work on Windows or UNIX. On UNIX you need to download the files from the server.

I will post the code in VB to get sequences if someone needs or wants it. It is a part of DwNav.

I think the issue is the time it would take to connect to update one of these. It would be faster in a stored procedure. You could do it in a function and return the current value if you are not using Oracle.

I got an email today asking this question. I have been thinking about this a lot lately. One of the reports that comes out of DwNav is Design Stats. This counts jobs, links and columns by category. The assumption is that one developer is probably working on that category. It would be nice to compare...