DSXchange

To use ODBC the string needs to be in ODBC-legal format, specifically CCYY-MM-DD for dates. If, for example, you are reading a string that contains a timestamp and trying to implicitly convert it into a date, you will get this kind of error.

I think you'll find that all the IsValid... functions expect a string as the principal argument. They report whether the string could be validly converted.

Not really, unless you create your own stage (BuildOp). On the other hand, you could use the Transformer stage itself to create HTML beginning and end tags for each field, particularly if the structure is simple.

The entire Transformer stage is rewritten in C++ at compile time, and this code is compiled and linked into a library/object (according to current settings). The performance hit is taken at compile time, not at run time. You may notice that a job with a Transformer stage will take longer to compile ...

Did you Search? One recent discussion is to be found here

prasson_ibm wrote:...it is not working as expected.

What do you expect, and what do you get when "it is not working as expected"?

What exact version of DataStage (from Help About)?

If the user is currently logged in from a DataStage Designer or Director client, then it is easy to ascertain the project to which that user is attached. For each such connected user a shared lock is taken on !&DSADMIN.projectname&! to serve as a quick way for administrative utilities to det...

Perhaps the XPath expression with the greatest number of delimiters?

"Arnd" <> "Andrew" even with a trailing capital "W".

"Unix" covers a multitude of operating systems, including AIX, HP-UX, Solaris and Linux. The compiler is different for each. Can you be more specific? As a general rule compilers for Unix operating systems are not free.

Use DecimalToDecimal() function in Transformer stage or decimal_from_decimal() function in Modify stage. In the latter case specifying NOWARN may also prove useful.

Then maybe the query genuinely returns 0 rows. Try executing the query using the Administrator client Command window.

Where exactly is the problem?
Can you View Data using the UniVerse stage?
Are there any errors or warnings in the job log?

It is illegal to copy licensed software to additional machines. Provided that the machines are of the same class, you should be able to move the compiled executables (objects, libraries) to the other machine without needing to have a C++ compiler on the second machine. If you want the compiler on th...

How many licences do you have for DataStage clients, and how many are attempting to connect at the same time?