DSXchange

murali, you first need to find out if your DRS source or your Oracle target is slowing the job down. Change your output in a test job to a local sequential file and see what the speed is. It is more likely that a WRITE is slower than the READ.

You can find this on page 8-5 of the "Server Job Developer's Guide".

Ahhh- I realized that after I posted but had to run off to do some work!!!! Thanks for the correction and explanation; I also want to caution against doing anything with the UV_SCHEMA file as it is possible to completely ruin an installation by messing up this file.

I would load your header sequential file to a hashed file with a sequential numeric key. In your job you will have a transform stage with a lookup to this hashed file. You define a stage variable to detect whether the current row has changed values in the first column, if so you increment a stage va...

You can do a "DELETE UV_SCHEMA Project2"

The column width for a fixed lenght flat file read/write is derived from the "Display" attribute and you need to set this to the actual length.

Yes, you need to get rid of the references in UV_SCHEMA as well.

It doesn't look too difficult. Where do you get your values for the column headings from? Another file?

tcj wrote:Don't forget to check for leap year :D

I would have done that in a premium post My favorite was is to do an ICONV on that output date and let the routine "clean it up" and tell me so with the return status code.

Where did you get the invalid run parameters from - the only sure method is to look at the director log entries. The error does sound quite odd and we all hate sporadic problems. Can you think of any outside factor that correlates to the problems happening (time of day, phase of moon [just kidding],...

sendmk,

if you input looks lik your output then you don't even need DataStage, either.

What is a

sequencer job in a seq file

and what exactly are you asking? There is no way anyone here who isn't clairvoyant can answer the question with the information you've given.

This tells me that your ED UV.ACCOUNT Project2 was not done correctly; confirmed by your not finding that entry when doing your SELECT * FROM UV.ACCOUNT... statement. What do you mean Is for the one which was deleted from unix - this is a different problem. I understood that you mistakenly deleted a...

What speed does a FTP from your DS server to the remote machine achieve?

Could you post the exact error message that your administrator is getting? Also, how is he/she trying to restart DataStage?

Since DataStage just passes the query through to the database, I would tend to assume that your runtime values for start_time and end_time are not correct for the invalid runs. Particularly as the error seems to return 0 rows - as if one of the 2 AND'ed conditions might be wrong. Check the parameter...