DSXchange

Please explain how the structure of a table can change between runs. If it is changed manually (for example via ALTER TABLE statements) then there is no way to automatically synchronize your DataStage job. Recall that DataStage job designs are driven by the metadata - not vice versa.

Search the forum for "BCI". The DataStage BASIC SQL Client Interface (BCI) is a set of DataStage functions that mimic the ODBC API functions. You can do whatever you like (in an SQL realm) with these.

What part of "not connected to ORACLE" was unclear?

From memory, LOC0020

Actually, that's not the case. You could create a small function (exposed by OLE Automation) that read the relevant registry entry and returned the pathname contained therein.

If you're already in DataStage, the System(32) function returns the pathname.

In parallel job Sequential File stage you can have multiple File properties for reading specific files, for File Pattern for reading files whose names match a given regular expression.

Do you think the email recipient might prefer the email to be in English?
Please use proper English on the DSXchange forum, it is difficult enough for non-English speakers to have to cope with correct English, much less with SMS-style affectations.

Use Print option from Project menu in Director, and choose Print To File check box.

Well, of course it COULD be done. But you'd only be doing with DataStage what we've already advised.

would work

No.

Welcome aboard.

Basically the answer is no.

StringToDate() function applied to the leftmost 11 characters of your string and with an appropriate date format string.

The actual format of the Date data type is irrelevant, but will be displayed according to your project's or job's default date format.

You can certainly use job parameters in simple conditions in a Filter stage - I have not checked a compound condition (one with And or Or) but can not imagine there would be any difficulty. However, it can be finicky with quote characters - try using single quotes rather than double quotes, for both...

What is the data type of the field? To what value did you set APT_STRING_PADCHAR environment variable?