DSXchange

Please delete the duplicate post before someone answers it. Do you have to fetch this mainframe file from the mainframe, or is it "pushed" to your DataStage server from the mainframe? Do you have a COBOL file definition for the mainframe file? If not, where are you getting its metadata (table defini...

There's a lot you have to do. There's even a whole manual about it, which you can get your support provider to supply. You could, in the meantime, Search this forum.

This is nothing to do with DataStage. It is the way that some SMTP clients work.

Search the manuals and online help for the term "date format string".

f(kN), where k is some constant and N is the number of items in the delimited list. That is, time taken is a linear function of number of items, for sufficiently small items (such as city names). Remember that this function is sorting a delimited list of city names for each record processed - it is ...

Why can't you use Switch stage?
Can you use Filter stage?

There's no single function. But you could build an expression that converts the date to the number of days since a given date, adds to that, then converts back to a date. Functions involved are:
DaysFromDateSince()
DateFromDaysSince()

There is a PDF document available from your support provider that goes deeply into the intricacies of setting up DB2 access for DataStage. I suggest that you ask for it. It answers all your questions.

You need to include "" as the default node pool name.

I don't believe that the NLS map property can be a job parameter.

No, but they are completely different data browsers - the server one is written in BASIC, the parallel one uses osh.

Welcome aboard. Why do you want to do this? The Len() function will return the number of characters in a string, which will be the same as the number of bytes if you are using a single-byte character set. Simply (temporarily if necessary) convert the binary to a string data type first. If you have N...

Easiest would be a server job (called from the job sequence at the end) to perform this task. It could interrogate the system clock directly (via the Date() and Time() functions for example) rather than selecting sysdate from dual.