DSXchange

I think you'll be lucky to find anyone who went straight from 7.0 to 7.5.2; most went first from 7.0 to 7.1 (when the latter was reasonably new) or to 7.5.1.

Welcome aboard. :D If you use a Transformer stage, and your data are sorted (and partitioned) on the column where you want to compare current with previous row, then you can use stage variables. Search the forum for techniques. Basically you rely upon the fact that stage variables are evaluated in o...

Yes.

If you have an appropriate version, namely 7.5x2.

A recently updated short (six page) white paper from IBM discusses why and how a 32-bit application (specifically UniVerse or UniData) is implemented on 64-bit hardware. The discussion is equally pertinent to DataStage.

Not forgetting that applying that dangerous little bit of knowledge may also invalidate your warranty, which means that not even support would be prepared to help you out of the hole (and justifiably so).

But your responsibility is probably to spread knowledge ... This is an all-volunteer site. According to my accountant, my responsibility is to sell knowledge - after all, it's how I earn my living. I am happy to share that knowledge here, but only to the extent that there's no danger of being sued ...

What is the actual status of the job, as reported by Director? (For example, the behaviour you describe would occur if the status were "Not Compiled".)

You can not write loops in the Oracle stage itself. Therefore you basically have two choices; use Start Loop and End Loop activities in a job sequence, as the others have suggested, or use an Oracle stored procedure.

Look for errors and warnings in the job log. Reset the job. Look for extra diagnostic information.

thatiprashant wrote:my time format matches for the job, but its still asking me to enter in quotes without that its not accepting

Just accede to its wishes.

Instead of running multiple instances of parallel jobs, why not just use a configuration file with more processing nodes? You can have more than one processing node on the same machine. Make sure, however, that you don't force sequential mode operation by writing via a Sequential File stage; use a F...

Is the "Run' button even enabled?

If it isn't, then your job is not in a runnable state. Status view in Director should indicate whether this is the case. In Log view you will be able to see whether it starts and stops, or fails to start at all.

Research that and let us know the result.

Search the (server) forum. This question has been answered five times to my certain knowledge.

Etiquette Notes
1. Start a new thread for a new topic.
2. Search before posting, or pay someone to do it.
3. Post in the correct forum.

Venkat's solution will not work in a server job because the StringToDate() function is only available in parallel jobs.

Double click on the cell that shows <<ERROR>> in the Test grid and report what is displayed there.