DSXchange

When you reset the aborted job in Director do you get extra diagnostic information in an event "from previous run..."? It may also be the case that your loading into the database table is generating 50 warnings so you are triggering your maximum warnings limit. Without you telling us what's in the ...

There is an audit trail. It is in a Repository table called DS_AUDIT on the server. Search the forum for more information, including the column names that you can use in querying this table.

In the Columns grid on the link(s) where this column appears, what are the SQL Data Type and Precision settings?

Use the supplied routines (Routines\SDK\Key Management category). Don't re-invent the wheel!

With 64-bit hashed file it's of the order of the smaller of 2 PB (two million TB) and the largest file your operating system will permit. Best performance will be had by keeping the hashed files as small as possible; for example the key values and row number only. Depends on what you actually need t...

Send two files - the DDS file and another "flag" file sent after it. The flag file can be empty, or contain a small amount of information. If DataStage waits for the "flag" file to appear, then the DDS file must have appeared, since its transfer was not initiated until the DDS file's transfer had be...

That's exactly the method I alluded to, and quite clearly described. You should be able to design it from that specification.

ray.wurlod wrote:And, as Kim says, ...

Not enough for you?

Maps do not support languages, they support character sets. Polish should be able to be achieved entirely within ISO8859; check the NLS database (how to do this is in the NLS manual) to find out which subset of this you need to include the accented characters. Polish characters ought, if my memory s...

When you imported the table definition from Oracle, how was this particular column defined?

Execute the command DS.CHECKER. Note what its output tells you. Again you will need exclusive access to the project. If the job in question has been partially deleted, it will be completely deleted by this utility, and you will be able to import/restore from backup. Please post results back here.

Trim() function is the one you want. Specify the "-" character as the second argument of Trim(), and the third argument is a single character code specifying from where you want them removed. You can learn all the options by reviewing on-line help or from the DataStage BASIC manual. A second possib...

Paraphrasing, at the very least. (A quote would have been attributed using Quote tags.)

DataStage does not, in general, have the ability to process BLOBs. If you think about the reason is obvious; DataStage is an ETL tool; what kinds of transformation are relevant - even possible - with BLOBs? If you search the forum you will find some workarounds involving encoding the BLOB, but you c...