DSXchange

If you can setup the job to run under multiple instances (unique file names, no locks, etc), then you could run several "configurations" from your csv file. The best option is to design the process so that it can run once and do everything necessary at one time for all of the values within your csv ...

Welcome aboard! Since DS is an ETL tool, it may seem cumbersome for such a simple task. You'll probably want a job per source table that writes to a sequential text file. Each target table will have a dedicated load job that reads the appropriate text file and loads the data. My assumption is that t...

Nope.

Okay, but you can always issue system command line commands via a CALL DSExecute(....). You can run dsjob as a command. Search the forum for DSExecute for ways folks have used it.

Some hashed file maintenance, lock management (see DS.TOOLS), etc.

There's no official DS documentation on the DS command line. There's a goldmine here, however.

There's no impact by setting the service to Manual and stopping it. You really want to leave this service enabled because you will need to release locks and clear up any internal repository glitches that may occur and this interface provides the most ability to do so.

If you are talking about your hashed files created within the DataStage projects, you must also dump them to files and create on the unix side. If you mean things like the hashed files used in the SDK functions, you must copy those over as well. The thing to consider on those files is to build a job...

They won't be in the same state. You're going to need to dump your hashed files to sequential text files, ftp them to the unix box, then load them into the hashed files on the unix side. This will cause your hashed files to build fresh. If you have STATIC or specialty tuned (minimum modulos, etc) ha...

Use an OCI/ODBC stage to select from the target table rows of interest, transform then however you desire, then pass the result to an OCI/ODBC to load. E T L

The stated issue is that if ControlJob#1 has attached and started TransformJob, how can ControlJob#2 attached to TransformJob and see its status? I don't believe two jobs can have a job handle for the same job simultaneously, but maybe I'm wrong.

To restate your problem, you are comparing the same query against two objects: create view big_view as ( select * from table_A union all select * from table_B union all select * from table_C ) and: table_ABC Both objects have the exact same data, so it's now a question of optimization. Given...

Read My Mind

Yes. But... Why partition on all three? Or is this just an example? All partitioning is used to do is distribute data evenly across multiple independent worker processes. Hash partitioning means that like values stay together, which introduces some skewing as a 99K out of 100K rows may partition tog...

Wait a minute, what do I mean welcome? You've been lurking quite a awhile. How about: Thanks for piping up!

Welcome! You can get the status using the command line program dsjob without needing a job handle. Otherwise, you can try to use DSAttach and see the value returned from a DSGetJobInfo and see if the return value is DSJE.BADHANDLE. I never tried it, but the DS BASIC documentation has to be correct, ...