DSXchange

If you do write something, make sure it finds any ODBC stage that is writing to a DB2 DSN.

It's not good enough to assert that there aren't any; you can't prevent someone from creating one. Your utility must be able to handle it.

And then there's OLEDB...

Don't know. Did think of a bad (low quality) and esoteric joke about argument pointers, which would appeal only to certain C programmers! In the interest of good taste and professionalism, elected not to post same.

Data Elements are like "luggage tags" for data. They are meaningful only within DataStage. For example, you have a ten digit number, defined with an SQL data type of Char(10). You have lots of these; they are different things. Some are telephone numbers, some are product codes, some are barcodes, an...

clear.file pathname is also available from the operating system prompt. The executable is in the DataStage bin directory.

Do you use a hammer to fasten wood screws? Or a sieve to cart water?

Use the right tool!

The Pivot stage does horizontal pivots.
The Aggregator stage does aggregation.
The FTP stage does FTP.
And so on.

That's the main principle underlying the graphical paradigm that DataStage uses.

DataStage is not a reporting tool. Use the correct tool, which is probably as simple as a query against your Oracle database. Use a CASE construct to form your intervals, and group by these. DataStage can certainly calculate your intervals as part of an ETL process, but will not generate a report fo...

It's good when the echo can provide specific examples not in the original! I believe that the Sort stage was never intended to be used seriously. It was a marketing decision; it had to be put in because INFA could do sorting, and was never really done properly. Hence the niche for CoSort stage and m...

Can you please look at the log in Director log view and tell us which timestamp is reported in the detail view? Note the event number. Connect to TCL (Administrator client Command window, or telnet session into DataStage). Execute the following query SELECT @ID, SEVERITY, TIMESTAMP FROM RT_LOGnnn WH...

I do have a routine (English equivalent of that posted by Muriel) that locks the log file, written more recently that the older post. It was constructed by capturing a server-side trace of various ways of purging a log, and replicating the calls to helper subroutines (and, of course, discovering whe...

It's nothing to do with your UNIX limits. The default size for the write cache is 128MB. You can change this in the Adminstrator client (as a project-wide default) or in the hashed file stage itself. You also may need to adjust one or two parameters in uvconfig, and regenerate before re-starting Dat...

Seem to remember having this discussion in March 2003! :D

I received a private message asking what is the function of the Inner Circle forum. The poster was concerned that there may be some vital knowledge there. I'm afraid my answer would have disappointed. Here it is. "Inner circle" is the name chosen for a forum purely for self-employed consultants. On ...

Mumbai.

Pass through Chennai on the way to Singapore on Sunday morning, but they don't let us off the aircraft. (Air India)

What's the setting of the uvconfig parameters DISKCACHE and DCWRITEDAEMON? Use CONFIG DATA to find out. Read the comments in uvconfig to ascertain what the effect of each is.

You have @USER0 thorough @USER4 and @USER.RETURN.CODE as writable system variables. They are all local to a process; that is, they do not have scope between processes. To get them to show up in the Expression Editor's drop-down list, edit the DSParams file on the server (this is entirely legal to do...