DSXchange

roblew wrote:Yes! Ray, this was awesome advice. It took me two times to run, but I followed the instructions above to clear the log.

It appears it also took you two years to clear the log!! My post was dated Apr 2005.

Anyone opening the job in Designer, or its properties in Manager, and making any little change (even moving an annotation) then clicking Save constitutes an "edit". This will change the job's status to Not Compiled until it is once again compiled. The DS_AUDIT table tracks edits made with DataStage ...

Is Field002 able to carry nulls? If so derive it as

Because DataStage server jobs do not have an intrinsic Timestamp data type.

For a finite, and reasonably small, number of values you could use a Filter or Transformer stage with multiple outputs to distribute the records to different files. But the individual file names would be hard coded, not calculated dynamically.

Clearing the DataStage logs won't recover all that much space. Make sure that &PH& and the directory pointed to by UVTEMP are kept as clean as possible too. Also periodically clean up any log/data files used by database utilities and which are no longer needed.

The error won't occur. Because you have no EVAL expressions in your SQL, there are no I-descriptor expressions (which are introduced by EVAL) to compile.

True. Red Brick is THE best database for star schema implementations. I won't bore you here with why, except to say that it's the only database specifically designed for star schemas. I installed a new site late last year, and I think I may have initiated another sale today. Unfortunately they (IBM)...

Including all foreign language representations? If you claim to write anything "generic" in DataStage you will need to make use of NLS locales, for example 23 AVR 2007 is a valid date in Canada, France and lots of other places.

If you exclude -wait and -jobstatus options you can start them from the one script. You do not specifically require dsadm access.

It's perfectly valid if the grants are made through a role.

Enrol on the IBM class "Advanced DataStage (EE)" (code DX436). Most of your questions on this thread are covered there.

You know about SETFILE from numerous discussions here. It creates a pointer to a remove hashed file in the current project's VOC file. COPY is a "UniVerse" command for copying a record from one table to another. It's easier to use than SQL for entire records. In this case you are copying the record ...

Under hardware include number and speed of CPUs. If you are in a cluster/grid environment, separate information may be required for each machine. If in a grid, some extra information about grid management also. Do you do everything in memory or do you have some disk? If you have some disk, how much ...