DSXchange

Basically SessionAdmin.sh -kill_user_sessions exists to disconnect any actively connected clients.

To continue Robert's theme, the thing you're looking for in the New menu is Lookup Table (TBL), which you will find under Data Quality.

Once the new table has been created, you double click to open it in your selected editor (default Notepad).

U is a fairly common Burmese name. At least one of our posters is named U. The second person personal pronoun in English is spelled "you". Not "u". Please strive to maintain a professional standard of written English on DSXchange. It is not a mobile telephony device, and you are...

PXPivot stage.

How is null actually represented in your Sequential File stage (for example the Null Field Value property on the Format tab or in an extended column definition)?

... Input.column1=@NULL... As noted earlier, it is not legal to compare something against NULL. One should use the IsNull() function to determine whether a field is (contains) null. In server jobs there exists a system variable (@NULL.STR) that contains a string representation of the internal forma...

Not all database types are supported for IADB.

It would have helped a quicker diagnosis had you mentioned the Citrix connection at the outset.

That's what the reject link is for!

Note, however, if your load method is Bulk, then you won't direct rows into the reject link. Instead, for Oracle, you will need to examine the log and bad files.

Does your target Oracle Connector stage have a reject link?

How have you set the following properties in the Teradata Connector?
Transaction mode
Client character set
Automap characterset encoding

@USER0 through @USER4 are system variables, not semaphores. You can store values in them.

The 64 numbered semaphores (and that number is configurable in uvconfig) are simply places to wait (via LOCK command/statement).

There was, but it melted.

A Char field cannot have a value of "".

Any change from a known value (even if "") to NULL is a change.

The DataStage Engine itself uses semaphores extensively to control various aspects of threading and locking, but I don't think this was the import of the question. The DataStage Engine also has available a set of public numbered semaphores that could be used for a similar purpose. I may have used th...