DSXchange

Constrain the output from the Transformer stage so that it only passes rows for which the lookup succeeds. It's not clear from your diagram, but the parent table needs to be the reference input. (Hint: encase your diagrams in Code tags, and use Preview to get the "ASCII art" right.)

In a server ODBC stage, put the double-quoted column names in the Derivation column in the Columns grid. It's these that form the SELECT clause in the generated SELECT statement. In a parallel ODBC Enterprise stage you're probably easiest to go with user-defined SQL, with double-quoted column names....

If you are using a Transformer stage specify SetNull() as the column derivation where you need null. If you are using a Modify stage use make_null() function. You will have to figure out what an out-of-band null for a date field looks like if you use the Modify stage.

There seems to be a missing newline character in rtti.h - do you have another instance against which you can check?

Another message was "Platform Not Recognized" which is a bit of a worry! I'd advise involving your support provider.

The compiler and linker environment variables look OK.

Absolutely. What you are describing is an MPP configuration (read about this in the Manager Guide - the chapter on Configurations). /* Two nodes, two machines */ { node "N1" { fastname "S1" ... } node "N2" { fastname "S2" ... } } ...

Are the hashed files read-cached? How large are the hashed files? How big have you set the read cache?

I still can't see that you have any proof that a character is "broken" whatever that means. It is possible to read one byte at a time and to determine the byte value and byte type, but you will need to write your own routine, and specify NONE as the map - otherwise the map will attempt to convert th...

Is this a parallel job or a server job? You've marked the job type as parallel but posted it in the server forum.

The answer will depend upon which it is.

Welcome aboard. In the menu at the top of the screen is a Search facility; we encourage people to search first for their answers, because they are usually here. There is a PACK (packaged application connectivity kit) available from the vendor for connecting to SAP BW. This provides stage types that ...

The functions you require are listed in this post.

What do you understand "no space left on device" to mean?

Time to do some housekeeping in the file systems, methinks.

Verify the syntax. Fiddle with it till you get a valid Open command. Maybe a trailing semi-colon (or two) is needed.

Or do the whole thing from scripts as also suggested.

What values are set for the following environment variables?
APT_COMPILER
APT_COMPILE_OPTIONS
APT_LINKER
APT_LINKER_OPTIONS
LD_LIBRARY_PATH

Check (don't assert) that the delimiter in the file is "|" and that the delimiter character specified in the Format properties is also "|". Whatever the delimiter character is in the file, make it the same in the Format properties.