DSXchange

There would only be an 'output' from the command if it failed. Check with your SysAdmins to see if sendmail is properly configured on that server.

No 'SQL queries' in the Transformer. Why not rephrase what you are trying to accomplish without mentioning 'sql' and see if people then could help more better?

On the subject of the runtime error, does this happen to everyone there or just on your PC? Also, what is the exact version of DataStage?

As noted, it is called 'dsjob' and it is fully documented in the Developer's Guides in the Command Line Interface section.

Ah... you will be whacked for use of the 'U' word, and in all caps in the subject at that.

Please explain this little snippet from your post:

throbinson wrote:The job must run real time

What he said.

Pretty standard stuff to look for / be concerned about when any application and database are co-resident.

Of course you have done something: the Only thing I have done is changed the filter from "Last Run" to "2 days earlier". A filter problem all along. One way to tell is to look in your 'status' line, the bottom of the Director pane where it lists 'Log for job: JobName'. It will show the number of ent...

The 'template' message is normal and can be ignored. Is your 'target email id' a job parameter? They can't have spaces in their name, hence the question.

Well, there you go - it's one of them pesky standards. :D

Obviously.

Databases seem to prefer single quoted strings.

Not quite there. what is it in the target table - DATE? TIMESTAMP? Answer :-- TIMESTAMP. Question :-- to what level of precision? what stage are you using for the Oracle piece of this? Answer :-- Oracle stage. Question :-- which Oracle stage? Last but not least, perhaps third time will be the charm:...

Plz post your complete Derivation. Since you didn't do that, I'll ask again. And now that other details are leaking out, clarify something. Your Oracle target field is a Timestamp in the job but what is it in the target table - DATE? TIMESTAMP? Plus - what stage are you using for the Oracle piece o...

Plz post your complete Derivation.

That is the expected behaviour. The truncation happens when the stage is 'opened' and the connection is established to the database, regardless of any rows actually going down the link.

Yes, Craig was joking about Arnd's use of "Latin countries". And knows all about what "Nova" (no vah) means in Spanish.