DSXchange

The BASIC functions do not apply to PX jobs, unless you specifically use the BASIC Transform stage. The functions availabe to you in PX are documented in the pdf document Parallel Job Developer's Guide

Welcome to DSXchange, Siji.

You can use the DSGetLogSummary() routine to retrieve the appropriate messages so that you can include them in the text of your e-mail message.

I recall that the help text is wrong, which is why I used the loop method I described earlier.

It is possible to have a job which has a transform stage as the source. You need to define at least one stage variable and also put a constraint on the output so that the job finishes. But this is exactly what you are trying to do - write just one record to your database with the value of the parame...

If I remember correctly, you can only attach to using the API and then delete a running job if your process was the one that started it. I think I ran into that issue a while back, but I'll check when I get to a DS computer.

Oops - I obviously had not had enough coffee when I responded, I mistook this thread for another. Can you login to the manager as your DataStage administrator and try the import (I still have a nagging suspicion the UNIX permissions are at the root of your particular problem). And I don't think that...

Are you certain that your lookup is successful on every row? If not, then the value returned will be null.

As Ray has already stated, just add a 0 to the number in a derivation and your leading zeroes will be stripped out.

Please create a dummy job in the original project (server or EE). Put one line into the job control "** This is a comment line", save the job and export it. Can you import this job into the new project? I think you will get the same error message and it might be due to insufficient access rights in ...

kashif007 wrote:..i dont know how do i fix a built-in routine. tblock is a built in routine...

tblock is not a DataStage builtin routine. It might be a user-written routine that you can find in the Manager under the "routines" category.

What exactly is being called in your before-job subroutine call?

Hello Xpert,

what user-defined SQL did you try and what was the error? Oracle sequences work quite well in DataStage.

There are some anomalies in your logic:
- Why are you checking for IsNotNull() when you assert that no nulls can be found.
- A CHAR(10) field can never be equal to ''.

The only way for a null value to slip into your logic is if your "Date" field is set to null upon a failed lookup.

try doing the same Ftp connection manually from the command line to see if it could be the userid/password portion or even the base ftp connection that isn't working. Are you sure you have an ftp server on the Windows machine running?

If you open up the Advanced Parallel Job Developer's Guide you can search for the references to APT_DUMP_SCORE. You won't need it since your problem is in the before-job routine. You can find it in your designer, job details. Once you know what is being called (it could be a DataStage routine or eve...

Please supply enough details to help locate the problem. Do you get this when you import DSX files? When you compile? When you run? What is the full error message and is it sporadic?

Also specify whether this is a server or a PX job and then post it in the correct forum.