DSXchange

Welcome aboard.

There isn't one. Data types are not enforced in server jobs - all conversions are automatic.

Moderator: please move to Server forum

Welcome aboard. The answer is "no idea". ConvertMember1ToMember2() is a BASIC function written in-house at your site. Without knowing what that routine does, we are in no position to understand what -1 might mean. Peruse the code of the routine (post it if that doesn't violate any non-disc...

Have you considered using an External Filter stage for your awk command?

There is a very old joke, though many say it's true, that goes something like this. A visitor to Ireland asks directions to a particular attraction, and gets the reply "well, if I were going there, I wouldn't be starting from here".

What if they're a DB2 shop? You've been in Ireland too long!

Are you referring to the worksheets as system tables? You have to for ODBC access.

It may be a locale file for the database (rather than for DataStage) that is missing.

It is correct that you need to do so. Whether you did so correctly remains to be seen.

Some of the DDL you seek is to be found in ${DSHOME}/../../ASBServer/bin/sql

Is any of the key columns VarChar data type and, if so, are they identically trimmed? (Don't assert - check.)

Try closing the Administrator and opening a new one. (There's no other way to get it to refresh, though it *should* auto-refresh.)

I suspect that IBM's position would be that, because everything is done through services, there is no way things can get out of synch.

We need more information about your job design and data. What do you mean by "mapped"? Can you publish a picture of the Transformer stage editor? What do you mean by "do not see any records in sequential file"? Are you using View Data or some viewer on the server? Are you indeed ...

What particular error message is thrown? It does no good to try to guess this.

You can use the server hostname as the mail server name on UNIX.