DSXchange

Check with you odbc source whether it really dose not have any data in it.
If the issue is with metadata mismatch, you would get a error/warning logged in. Check it seperately in a new job, by diverting the odbc to a sequential file or dataset and make sure you get the expected output.

performance stats in designer should give you more or less same as Director, thoug both may not be as accurate as the actuall data flow.
Pls explain the job design, and also make sure whether you job is still running or its just the status shown by the client windows.

While installing you client are you not prompted with
1. Install Server Software
2. Install Client Software
3. Intall Version Control
......

Change capture stage does an implict lookup/join and a change detection in it. If you are going with this stage, and if you are much concern to not to use lookup stage, you done with it.

Connect back to server and stop it
There are several ways discussed, so a search. Advisable way is thorough Director client.

As mentioned, define what is 'bad record' in you case?
Is it alwasy 6th and 7th in order?

How do you want the 5 sequencers to be executed if 'main' should be executed after all the 5.

The 'abnormal condition' is again not particular to a database or datastage or to operating system, or to netwrok... If you assume it is database, yes you will get the log out from the job. If the database is full or transaction log is full, load to the database will be aborted and hence the job, an...

Do a unload from the table. Do a chance detection. (It can be done by doing a lookup against the target with the input rows) Optionally you can maintain a flag for the exist records. Replace the Target with those rown with the Exst flag. Or you also a have 'Write Method' as Deleter Rows in the Oracl...

What is the type of parameter in the job and Jobsequence for the timestamp? Is it string or date or time?
Just try to write the same to a sequential file.

So I guess you have few many issue to lookup on. As observed by thompsonp, The metadata for an Oracle number or number 38 defaults to Decimal(38,10). might be a valid information. I am getting data from one of the JOIN sets but not from the other. You mean input dataset is not getting read? data loo...

Discussed Several times. The response from my support call to Ascential is that there are 3 manual methods to delete invocation entries from the Status View in Director: 1. Manual Delete 2. Clear Status File 3. Re Compile Do a search you can find some interesting routines developed by our website to...

Iam not much clear with your requirment. Do you need to access the value of the variable (parameter) set in the job sequence and pass it to underlying job? Or do you need to access the value of the parameter set in the job to the job sequence which calls it? Or do you need to access a value of stage...

As mentioned use Start loop activity to pass the value of n to the funtion field("Hi,How,Do,You,Do",",",n) which lies in routine acitivity. The output of the routine activity for each loop can be passed to the subsequent job activity as a parameter.

You an use Looping activity in Job Sequence to have a loop for 10 times and pass the value of n to the job 1-10. So that you can retrive nth row for each iteration. Pass on this value either as UserStatus or write into an external file and read it and pass it as command output through Execute comman...