DSXchange

Define "performance".

Some observations. 1. Internal time is not seconds since 1970. 2. Current date is more easily returned by Date(), current time by Time(). Current timestamp in seconds (since 1967-12-31) is simply 86400 * Date() + Time() 3. You do not need to preprocess using DCount. Instead of a For ...

I don't believe so.

As suggested this can not be done in the job itself. However the approach suggested by gateleys adds an unnecessary layer of software; instead of a Routine activity, I would recommend an Execute Command activity to execute your script, upstream of your Job activity in a job sequence. The activity va...

I would strongly advise against using the DataStage API functions on a row-by-row basis. If you must, however, use DSJ.ME for the job handle argument. What precisely do you need to do? I can not imagine a scenario that would require knowledge of row counts to generate keys. The current row count is ...

No, no, a thousand times no! The source-to-target mapping document will not keep track of anything - it will specify the sources, targets, mappings and business rules. If you could convince the Business Analysts to produce target-from-source mapping documents you might be closer to something akin to...

Segmentation fault = you ran out of memory.

Perhaps I don't understand your question. First you say "I need to create a data dictionary of directions", now you say "I cannot create the dictionary". Is it that you can not create a dictionary? Or is it that you can not create a dictionary that handles multiple formats? QualityStage does allow y...

In Director client choose Clear Log from the Job menu. Select Immediate purge option, and your settings in the Immediate purge frame.

I'd be inclined to convert the string to a date, rather than convert CurrentDate() to a string, because chances are that you will require it in a date format further downstream. This is possible when reading it from file, by specifying the appropriate date format string ("%dd/%mm/%yyyy") as a field-...

First task is to check the branded_odbc directory on the server to determine whether the license files are actually there. The branded_odbc directory is usually a sibling of the DataStage engine directories (DSEngine and PXEngine).

A normal lookup is performed against a virtual Data Set associated with the reference input link. A hash table (index) is built "on the fly" so that keys can be found quickly in the virtual Data Set. Therefore a normal lookup shows as a composite operator in the score; one to create the lookup table...

The 32-bit DB2 library is required because DataStage IS a 32-bit client. The 32-bit DB2 library is entirely capable of communicating with a 64-bit DB2 instance.

Many. It is highly likely you will not be able successfully to promote your jobs into a lower-versioned production environment. Even if you can, there is no guarantee that they will work properly. Any 7.5.2 functionality that you employ, deliberately, inadvertently or by default, will not be able to...

They are stored not in a database at all, but in a text file called DSParams in the project directory on the server.