DSXchange

Are there any nulls?

Concatenating anything with null will result in null.

Otherwise show us the exact expression you are using.

Then please mark the thread as Resolved using the green button at the top of the page.

(An approach using user status was going to be my next suggestion, but I had to check your syntax because the function you posted had mismatched parentheses.)

Round Robin should be the fastest mechanism. Perhaps you could increase your inter-process row buffer size.

IA does not work that way. Conceptually the process can be explained in SQL terms, something like SELECT CAST(col1 AS VARCHAR), CAST(col2 AS VARCHAR), ... FROM table but it's really using ODBC API functions. You could, of course, start an ODBC trace to see what's happening. The raw data are then dum...

Learn how to Search DSXchange. Both of these questions have been asked and answered before.

Are you missing a right parenthesis in the expression?

I've taken off the premium designation, because you didn't really miss much.

I don't have a solution but, as a workaround, can you use a Row Generator stage with a cycle of values in each of the five columns and generating precisely the same number of rows as there are values in each cycle?

This is related to your question about detecting non-English characters, isn't it?

One way would be to use a BASIC Transformer stage in which (possibly in a server routine) you use Oconv() to test whether the data can be "converted" using one kind of NLS map, perhaps ISO8859-1.

Until you can get WebSphere Application Server started, you won't be able to export anything. Perhaps you could disable security, which should at least allow you to get into the WAS console to reverse any changes that broke things. But be aware that the other components (Information Server) won't wo...

I agree. DaysSinceFromDate() can answer both questions (since start of year and since start of month).

Is it the case that EnglishName1 = EnglishName2 and JapaneseName1 = JapaneseName2 ? And EnglishName1 <> JapaneseName2 and JapaneseName1 <> EnglishName2 ?

If so, all you need is a simple constraint expression, InLink.Col1 = InLink.Col2.

membership.director@dsxchange.com is the correct email ID (or is it membershipdirector@dsxchange.com?). You can also try editor@dsxchange.com

Craig and I are just regular posters (admittedly with a large number of posts). We are not involved with the running of the site.

RDMS is a proprietary database that runs on UNISYS mainframes. There is a Windows-based ODBC driver called UniAccess that can be used to get at tables in this database. Does anyone know of a UNIX-based ODBC driver? I've searched in the most likely places (such as driver vendor websites) with no luck.