DSXchange

No, that's the NLS map. NLS has both maps and locales. I asked about the locale. Each locale has five categories; COLLATE, CTYPE, MONETARY, NUMERIC and TIME. I asked what your CTYPE locale category setting is.

There will typically only be three entries per invocation ID in the status table. I don't have access to DataStage at the moment, but executing the query I gave earlier will show you the structure of the keys. If you post the result of that query here, and tell us one of the invocation IDs, then it ...

Have you bothered to Search DSXchange?

Are you working on the same project as pradkumar?

Welcome aboard. Iconv() and Oconv() don't know about fractional seconds; you need to isolate these and add (concatenate) them back again later. But, if what you posted is your input string, then you ought to need to do nothing to it to load it into a Timestamp column in DB2. It's a perfectly valid t...

You can not protect the source code of the Routine, since it is a row in the Repository table DS_ROUTINES. You can make it read-only (to all) via the READONLY column. But this would not prevent anyone from inspecting the code. If you really want to hide a routine, then you have to resort to a mechan...

Answer this yourself. When you set up a DSN does it refer to a workbook or to a worksheet?

If it refers to a workbook then what you propose is probably do-able, most easily with a Routine that calls SQLTables() - a BCI function.

Tip: always use the expression editor, so that you always get the correct syntax for operators and operands.

And then, Connectors (particularly) and Enterprise stage types are supposed to be faster than API (plug-in) stage types. So please be wary of assuming that what was true in earlier releases remains true in new releases. "They" do a lot of work on identified bottlenecks.

WHAT warning message? Use copy/paste so that we see the exact message.

ANALYZERPROJECT is the reserved name for the DataStage project used by Information Analyzer.

By (a) posting in the correct forum (probably General in this case) and (b) getting the terminology correct. A sequencer makes an any/all decision about whether its inputs have fired - it is a component in a job sequence. Once your question is posted in the appropriate forum a more exact answer may ...

I've really run out of ideas. I assume they're all ordinary tables. You've said you have all requisite privileges, even to system tables, and the fact that you can import some tables' definitions seems to bear that out. I'd take a punt that the problem is in how the ODBC mechanism is set up; after a...

Welcome aboard. What is the setting of your NLS Locale CTYPE category?

What are your business rules? For example what do you want to get when you add one month to January 31st? To May 31st?

Please format your code and post the formatted code, inside Code tags. I suspect you have one END statement too many, which might be why Return is "not working". You ask about returning from a job control routine. Just falling out the end will do it, as will a RETURN statement properly nested. Your ...

There are two expiration dates for a Type 2 change. Have you perhaps missed the one for the expired record? Otherwise keep trying things like double-quoting the date, for example "2999-12-12".

(As is often the case I am typing this in an airport lounge and do not have access to the software.)