DSXchange

None of which I'm aware. Unless you want to write your own, of course.

Moderator: please move to Enterprise Edition forum

(moved)

Use a server Sequential File stage, either in a server job or in a server Shared Container in your parallel job.

The ODBC stage generates both SQL statements. Which one it uses depends on what kind of link (stream or reference) its output link is.

Yes, it supports InfoSphere Metadata Asset Manager.

Nothing to do with Islam at all!

Is retuning multiple rows from db2 enterprise stage possible in server job ? No, because there's no such thing as a DB2 Enterprise stage in a server job. That said, I don't believe that the DB2 Connector (which IS available) supports multi-row return from reference link. The ODBC stage, however, do...

Who mentioned hashed files?

Do the lookup against DB2, and allow multiple return rows from the reference link.

May the 4th be with you.

:D

Simply hard code the column names "c1", "c2", "c3". DataStage will not permit numeric column names. You can change them downstream if necessary (and in row #1 only).

So you're using an ordinal date (year and day number within year) rather than a Julian date (days offset from a known zero date)?
Try "%yyyy%ddd" as the format string.

Do it prior to the Column Import stage. Perhaps a Filter stage, perhaps a Transformer stage.

In server jobs the Transformer stage itself determines which output link (if any) is the reject link. It should be last in output link execution order, since it handles any row that has not been processed by any prior output link. Null and zero dates won't necessarily be automatically handled. This ...

You could, for example, do it via lookup in a Transformer stage.

Both things are happening.

The ls command puts a newline at the end, so as to position the cursor on the next line when issued interactively.

DataStage converts all line terminators to @FM so that applications are portable across platforms.

No. You must re-install to install NLS.