DSXchange

Cat the files together pre-job, read in the concatenated file and ignore the current sequence number. Assign a new one as you write the file back out using @OUTROWNUM as the derivation. Constrain the output to skip the embedded header records when the first field has a value of "GLORDDER".

That's more of a 7.x solution and not as applicable to the 8.x world. How about you explain the problem you are trying to correct instead, what does "designer and director jobs not in sync" mean?

Welcome. For the -file option, you'd need the actual password value in the file and would thus not be able to use the environment variable. User-defined Project level environment variables created using the Administrator are only instantiated into a job's environment when a job runs, so would not be...

about the meaningful names, i think ETL's are more likely a tool that you only want to see the final product, no the process itself. As long as the process take a variable from his source and write/update or what ever action it does, in some place returning a comprensible value acording to the olde...

Recall that we said that they would not "start at the same time" but rather one would start, then the second would start and they would run in parallel after that.

There's no "transaction size" when sourcing from OCI, you posted something "like" your query and zero is not a valid array size, so it's hard to believe that anything you're saying is correct. :? How about answering the sqlplus question? Also, is your "5-8 hours" spent ...

:? Where did DSJ.PARAMLIST come from? Read the help - that is a list of the parameter names in the job, not values passed to the routine. My code as posted assumed a single argument passed to the routine with a delimited list of values. Since your post is now marked as "Resolved" can you p...

Note I did say "to that" not "on that"... you'd need to check all the way up from root. Just trying to cover all the bases.

Job would run on the UNIX server, so no ".exe" file there. Why not just use the built-in Windows Scheduler on your PC?

Some advice... I really don't think that will work for you like you think it will and even if it does it's not something I'd declare to be "more clear" or any kind of efficient. DSJ.ME means "a handle to the current job" and DSGetLinkInfo is not a macro but rather a function. And...

In sqlplus it takes 10 minutes to get the complete result set or to start returning records? Two completely different things. What are your OCI settings - array size, transaction isolation, etc? Are you connecting as the same user, sqlplus versus DataStage? ps. That's not a valid hint, it requires a...

OK, let's say your arg list was passed in as a pipe delimited string rather than individual values:
The syntax for all available functions are in the online help.

Do you have "execute" permissions to that directory? That is what controls your ability to "cd" to it.

Don't use parens, use angle brackets for the array element. Me, I'd pass in the Args as a delimited string and then use Field() in the loop to get the proper value.

And when you start next time, will you refresh the value in the file from that target table (best practice) or does the job need to do that? If the latter then use an Aggregator to capture the max/last value used and write that back to the file.