DSXchange

I doubt it. I suspect the Ebcidic to Ascii conversion is the bottleneck. For testing, ftp the file, without any transformations, just a straight load to a flat file.

Great. Mark the post as resolved then.

Do a select max(key) from table and store it in a hashed file keyed on a dummy key say "X". INside the transformer, specify a stage variable and in the initial value of stage variable, call UtilityHashLookup() routine and get the max value. You can then keep adding @INROWNUM to it to get the next se...

If you are on 7.5x then you must be having exception handler. Connect Job A to it. See how exception handler works.

Becuase 000000 is not null. Look for '00000000', if found, set to null, else apply the StringToDate() function.

Invocation id could be anything. A running number maybe. You could use loop until to loop through the job passing a running number each time. And exit the loop when the running number equals 5.

What do you mean by "pick the sequences" ? Do you mean "Get the max" so that you can continue from there or "continue generating sequence in oracle" ?

I doubt the job handle "DSJ.ME" will work there. I am not too sure about that. If thats the case, you will have to write a small routine that creates a handle for that particular job and then gets the Row count for that particular link and returns that value.

What happens when you remove the -wait and just put -jobstatus?

Where are you giving that expression? Inside a job or job activity in a sequence job?

Better yet. Make a copy of your present job, delete Job2, connect job1 to job3. Once your done debugging. Run your original end to end sequence. This way your debugging is done and your sequence remains untouched.

Provide

What is the derivation that you are providing? Post all methods you have tried, specifically the format you are giving for the conversion.

Well the way I see it, you can do it in two different ways
A) Call the second script from within your master script.
B) Let your second script spit out the table name to a file. cat the file from your master script.

The format was messed up. Use the following: For #1 StringToDate(DecimalToString(YearFromDate(CurrentDate())-1):"-12-01", "%yyyy-%mm-%dd") For #2 If MonthFromDate(CurrentDate()) = 1 then StringToDate(YearFromDate(CurrentDate...