DSXchange

Ok, can you read define this sequential file in a Server job and do a successful view data on it?

Bala_135, you really should have seen that the reaction to posts marked as "urgent" automatically puts them at the END of our list of things to look at. Anything you consider urgent needs to be addressed to your support structure - that is what they get paid for. As this site is frequented by people...

So you wish to send an e-mail when the job has finished and no rows were written down a specific reject link? Yes, but you can't do it in a transform stage (unless you know how many rows your input stream has). This is because you won't know that you have no errors until the last line has been proce...

Kaps,

it means that your sequential file couldn't be opened for reading. Either the path/filename or the permissions are wrong.

The @INROWNUM value will never be 0 or < 1; since in that case the transformer would never get executed. This seems to be your problem and is not related to sendmail. What exactly are you trying to achieve? If you want to send a mail only one time when you have one or more rejects, then put a transf...

The job can have different results because your ENVironment settings can be different between running the job in a shell and running it from a DataStage job. Does your script require environment settings or paths to be set? If you check your Director logfile it will print out the job's environment s...

If you did a cut-and-paste of your command into the post, then you have an error "- password" instead of "-password".

Hello RStone, in this case I do not think that VarChar is the culprit, it is one of your file-level formatting options or specific settings for your first column. You are adding a binary length value where you do not need (or want) to. I can't open a PX designer window to list the specific settings ...

I didn't know who it was until I used google

BTW, this is not an example of classic "thread creep", we have now performed "thread transmutation"

You should try running this job in production with one node and/or set the lookup stage partitioning to 'complete' as I suggested earlier. It still looks like a partitioning problem.

Jozef, Using SQL in your case to delete a couple of records is going to be very inefficient. You could write a routine used in a derivation to delete records. Here is an example (most of the error handling skipped) that is tuned for efficiency but only handles one HashedFile. Routine DeleteHashedRec...

Hello Harsha Kumar, The answer to your question is that the routines will not be compiled at import time when using the Manager. If the routine is compiled when you used the Manager to create your DSX export file the object will be included with the export and that will be used when importing; so yo...

Hello Harsha kumar,

Once a repository object is overwritten the old copy is irretrievably gone, there is no undelete possible. You will need to restore the old version from a backup copy.

Nripendra, when your PX job runs what does the Monitor or job log show for the number of rows processed in each stage - that way you can see which stage is dropping the records. Unless you have a constraint or are doing processing the only way that DS will drop rows is when there are data driven err...

Christina,

is the file dssendmail_template.txt present in your project directory and are the permissions set so that the userid your DS job is run as can read it? IF the file is there and readable can you see when it was last changed (does it coincide with the time that e-mail stopped working)?