DSXchange

From the "How do I create a C++ routine and call it from DataStage?" department, this should be a good starting point. It's for 8.5 but I don't believe the specifics have changed, if you dig around there you should be able to find the 11.x version of this documentation. General question to...

Wow, that sucks for you to draw the short straw for the task, this is especially tough for someone with no knowledge of neither the 'before' nor the 'after' product. Never mind that this is (in my humble opinion) a complete waste of time and resources. Moving on... To again attempt to answer your qu...

Lacking that, a couple of other thoughts for your version:

viewtopic.php?t=152792
viewtopic.php?t=146613

There are more out there, you're not the first to ask this question.

Why? The places where those server routines are used really don't support parallel versions. :? And there is no "given below", wondering if you meant to post the BASIC code. What kind of help are you looking for, the BASIC reference? If so, there is this online reference and as it mentions...

... and your experience with the tool. From what I recall, they are brand spanking new to it.

He just means have the app changed to push the data to staging / interface tables specific to this processing and then have DS source from that database directly, turning it from an Excel Files Goat Rodeo to a much more standard "ETL" process. Most times you won't have the option of gettin...

Sorry. Stepping away from the keyboard...

There's no "problem" with processing those files, per se. CSV files should be trivial, native Excel files on a UNIX machine much less so. And the file management could be quite extensive but all of that is perfectly doable.

Your alternative idea sounds much... easier.

Where does this other application run? Typical answer would be to leverage dsjob from the command line on the ETL server. Is that a possibility?

And failing the ability to mount them on your ETL server (can't remember the last place I worked where that was allowed to happen) you'll need to look into a script of some kind to do the remote wildcard file existence check. Or if your version supports it, use an FTP source in a job to do basically...

Understood and that's exactly what I'm worried about - that there is a bit of over-thinking or over-engineering going on as the use of parameter sets with value files were meant to make everyone's life easier, not harder. :wink: USERSTATUS is an old, Server job concept that is typically fairly easy ...

Unless I missing something, I don't see a need to play any Execute Command games with the values file. The job should be using the parameter set and when you build out the value file associated with it, the job uses that automatically. Granted, I haven't been following along before this so perhaps y...

And, stupid me, just caught the fact that you were talking about files rather than tables. Got all excited and thought I could help yesterday, it was not to be. I'll leave it here on the chance that perhaps it helps someone else... some other day.

Very... interesting. Glad you figured it out.

Ah... Ray Wurlod, the bright light that blinds posters to any other reply.