DSXchange

It's an 8-cpu box. The aspect of this that really bugs me is that I copied this process from another successful DS job I wrote years ago. That job is still running without error! I'm digging deeper into the bowels of this beast, and I found this in &PH&: DataStage Job 318 Phantom 3500 Progra...

When developing PX jobs, I occasionally get abends. I go to Director, either hit RESET or CLEAR STATUS FILE, then attempt a recompile of my job. Quite frequently I get the message: "Cannot get exclusive access to executable file for job xyz" 1) What is this? 2) How can I easily avoid / cor...

Thank you for replying!
We just did that and received the same error.

I set a trace on the job and I noticed this:


Program "DSD.RUN": Line 2407, Unable to unlink the operating system file "ade.prod.<jobname...>.#1.BASIC_Transformer_43.DSLink44-Output".
Program "DSD.RUN": Line 2407, DELETE failure.

What's this about?

We're running DS 7.1. This is a simple parallel job that reads a Teradata table and writes to a lookup file and a flat file at the same time. This is the only error I get and it happens right after I initiate the job (dies from the dsjob command line and in the GUI). I'm using a basic transformer al...

Where can one go to get a definitive reference for DS error messages?

I'm trying to insert rows into a UDB database and I get this cryptic msg:

Plug-in stage property (TARGETTABLE) is not defined for Stages

TIA

We upgraded to 7.5.1 a few months ago. I would have thought the patch would be contained in the cd they gave us.

cbres00

If that's your only problem..... then you are problem-free indeed!

Indeed!!
I'll test and report back.

Hope all is well with you in FLA.

cbres00

I did think about that. :D In fact, that's my backup strategy for any goofy things like this.

I've never used a Modify before. Got any tips?

Regards,
cbres00

Teradata stage for the Teradata piece and DRS for the MS SQL piece.

cbres00

I'm doing a straight (no transform) extract from a Teradata table to a MS SQL table. Both the source and target cols are varchar(50). When I look at the target table in MS SQL I see that the rightmost character in the varchar(50) field is truncated! I put a transform between the stages and stuck a p...

How would I call a shell script from a job seq? This will open up a whole world of flexibility for me if I knew how to do it!

Regards and thanks,
Cathy

I create a flat file in one of my job sequences. I'd like to archive it with a date and timestamp at the end of my job sequence.

Any elegant/simple ways to do this?

TIA,
Cathy

I got this error: The number of input links must match the number of input datasets. I have a list of transaction ids I've put in a fileset to use as a reference for several jobs in a sequence. I need to join these transaction ids within Teradata APIs to do some updates and data moves to those rows ...