DSXchange

Nige

I think you need to get rid of the IPC, buffering and maybe the link collector to make this work. That is just my opinion. I have not tried this combination. I am sure Ray will tell us why.

I wonder if you can post the foreign key statements to make this work.

Do an exact search for EtlStats.

What version of DS? What version of Windows? What server?

I would use crc32. Do a search on how to use this function. I would think this would be the fastest way to compare all fields.

Do an exact search for READONLY.

You could always import into Access and then copy from Access to a linked table in Oracle. Otherwise you need to call support.

Ray knows we appreciate him. He complained the most about the current graphics. I say give Ray whatever he wants.

You are probably right. It is only for Designer but may impact VC based on its design. The bug seems to be when someone has the job you are trying to promote up in Designer therefore it si locked. Nobody has proven this but it makes sense. It cannot get the job it wants so it promotes the wrong job....

Do you have the XP patch for DataStage loaded?

Command Stage has a bug in it in older versions. You cannot feed parameter values to the command. It will look okay in the log but does not work. Change the stage to Routine Activity and call ExecSH or ExecDos. These work fine.

This is exactly why I hate sed, awk and Perl. It is almost unreadable. They are powerful but impossible to maintain. Assembler is great for the same reasons.

I would do like Ken. BASIC is so much easier though. If you did this in a shell script you would need to parse one field at a time using cut -d'|' -fx where x goes to the end of the line. I think if you where clever then Perl would work because you want * between ] and [ or |. Sed and awk can do all...

Before routines are stored in field 9 and 10 has after routines in the ROOT record. SELECT EVAL "@RECORD<9>" AS BEFORE_ROUTINE FROM DS_JOBOBJECTS WHERE OBJIDNO = (SELECT JOBID FROM DS_JOBS WHERE NAME = '<<Job Name>>') AND OBJIDNAME = 'ROOT' ; I stole this code from Ray's post yeste...

I will hack it later when I get home.