DSXchange

Yes.

It's not a DataStage error - it's a database error (invalid identifier). Try qualifying the table name with a schema/owner name. Check, too, that every one of the columns you've named belongs in that table and that the alias name you've used doesn't. Is it legal to use expressions in the WHERE claus...

Can't you use the basename command? If not, research the tilde options (particularly ~n) for batch script arguments with the DOS shell. Type HELP CALL at a DOS prompt. Yet another possibility is to treat the pathname as a set of backslash-delimited strings. Field(InLink.Pathname, "\", DCou...

Does anyone have information about the trace type and trace level properties in the Standardize stage?

There's nothing in the manuals or in the Information Center that I can find.

DataStage Version Control was retired at version 8.0.

Information Server Manager allows you to interact with source code control systems, perhaps via the Eclipse plug-in for that SCCS.

Welcome aboard. To my way of thinking, RANK is a display function, not something that an ETL tool should be asked to do. It is possible, which a Search of DSXchange will reveal. Begin by formulating your complete logic in English - this should readily translate into operations in the ETL job itself.

Well, you could look at them. Incidentally, there is no file called DSParam (it's called DSParams). There is one dsenv file. It resides in the DSEngine directory and, primarily, sets up environment variables globally for all DataStage processes. There is one DSParams file for each project. It reside...

There are times when version control is not used promptly? A big stick.

Yes. And, by default, it's in the XMETA database, though in its own schema (DSODB).

Welcome aboard. Have you tried creating the report within DataStage Designer? Those reports do include comments, and are subsequently accessible within the Reporting Console. I do not know why you can't select jobs within the Reporting Console - can you take us through the exact steps you are using?

15K might be the point where a differently-sized record is first encountered.

I believe that that (or DIR /B, its Windows equivalent) is what the OP is doing in the Execute Command activity.

My advice in the earlier post is predicated upon that assumption.

You can do it, but it's problematic specifying the delimiter to the Start Loop activity. What we usually recommend is a User Variables activity to convert the line terminators to something else (maybe comma) so that you end up with a comma-delimited list of file names. Convert(@FM, ",", Co...

The automatically installed instance of WebSphere Application Server for InfoSphere Information Server v8.x must be a dedicated instance, but is automatically licensed.

ghutchin wrote:We need all the 2 byte uft-8 chars escaped from a file.

On whose authority? These characters are still part of your client's data.