DSXchange

Are you using TENACITY? If not, an process that can not get a Teradata session will abort. It may be this that you are seeing, and would explain the apparent randomness of the behaviour - sometimes processes can all get sessions, occasionally one can't. TENACITY will allow such sessions to wait. (As...

NULL is not accepted as the primary key of a hashed file.
Duplicate key values are not possible in a hashed file.

I guess you could mark it as resolved, then.

You can effect the same behaviour in DataStage BASIC, for files opened for sequential access (but not for hashed file) using statements like NoBuf and WriteSeqF.

If, as you say, the environment variable is a job parameter, you can use the DSGetParamInfo() function to retrieve its value.

"Me" is a very common concept in object-oriented programming - it refers to the current object. In DataStage, depending on the function, the current object may be be job, the stage, the link. In DataStage BASIC the constant DSJ.ME serves to identify the current object.

Whenever creating routines that some other induhvidual may call, you need to check for three forms of invalid argument - unassigned, null and otherwise invalid. If UnAssigned(Arg1) Or IsNull(Arg1) Then RETURN(@NULL) ; * return immediately End If Arg1 = "" ; * for ex...

With a UV stage you can specify whatever SQL you need to do your job; for example, if you sort by the lookup key and don't use multi-row return, you would get the highest value that meet your criteria.

Your requirement to abort the job is unnecessary. A far better design would be to check that the row (or key value) in question does not already exit in the target table before attempting to insert it. Any row that does already exist can be captured in a different ("reject"?) stream and processed ac...

It means that there is at least one field in your job design defined as VarChar but without a Precision (maximum length) value. While this is legal in some places (for example Data Set stages) it is not legal in others. Whichever operator governed by your particular combined operator controller is c...

Probably delimiter characters (commas) in the data. Are character strings quoted in the data? If not, it would be a good idea to make them thus.

Orchestrate's orchdbutil method is more accurate than plug-in stages, particularly for Oracle, and particularly for decimal/numeric columns.

The ones in Samples are for would-be plug-in writers. Find the dsp files under the appropriate folder (e.g. Oracle).

Whence did you purchase DataStage? That's your vendor.

If you haven't (yet) purchased DataStage, your local IBM office should be able to indicate where you can do so.

Welcome aboard. :D

Technically this is hijacking the thread, which is frowned upon - your question does not relate to configuring a DSN. In future please begin a new thread (choose "Post New Topic").

The Orchestrate method is more accurate, particularly with decimal/numeric data types.

Welcome aboard. :D The Sequential File stage can have a second output link, called the "rejects" link. This link will capture, as a raw string, any row that does not match the metadata (table definition) being used to read the file. Subsequently in the job, rows on the rejects link can be reprocesse...