DSXchange

How did you start the job - the warning settings are changeable when starting the job.

I would use the following logic:

1. Convert the DSJobStartDate to a string in the format YYYY-MM-DD
2. Replace the last two characters in the string with 01
3. Convert the String back to a Date
4. Subtract 1 day from the Date

In your DataStage job use "CONVERT(Char(13),'',In.StringColumn)" to remove internal Control-M characters.

What is your source data type, are you doing an implicit conversion to float in the transform stage?

We did something similar at a project in the UK once, I think we called the application the "throttler" and we also put a lot of thought into which metric we were going to use in order to decide whether or not a new Job could be started or have to continue to wait. It got complicated, there were 2 t...

No, the FTP stage makes direct FTP calls. If you need to use SFTP then it will have to be done by invoking it directly and then transferring the file to the DataStage in order to be processed.

runtime column propagation is used throughout DataStage PX jobs.

Your lookup is set to "fail" if not successful. Change the lookup stage settings.

Yes, make sure that the specified path is valid.

Did you specify an absolute or a relative path? Does the file exist in the path specified? Does your userid have access to it?

Which formula did you use for your "Yield to Price"?

What value does it get in the script?

I don't know what to do. You don't have any examples or details and nobody knows what your job does or what your environments look like. I think that Ray has a RMM stage that might help, but that is going to be the only hope unless you can provide some details.

No, DataStage does not reserve it's own space. The command is a holdover from the UniVerse implementation on PRIMOS, where the STATUS command was commonly used. On UNIX the "STATUS" command executes a "ps" command, I can't recall what the corresponding one on Windows is.

What stage are you using? Are you using the same 3 values in the job, particularly the service name, as you did in the SQLplus command?

Thanks, sjfearnside - I was still in V7 mode!