DSXchange

Welcome! I'm thinking your issue is memory related. 256mb is a small amount of RAM by any standards nowadays - barely enough to run XP - and that's a pretty large file to import. This problem is aggravated by the fact that the first thing the Import process has to do is convert the entire XML file t...

One other thing to note is the difference between using -wait and -jobstatus when running a job. The former waits for the job to complete but passes back the exit status of the dsjob command itself - could it start the job or not. You need to use the latter if you want to pass back the exit status o...

NFS mount or an equivalent mechanism. Or work locally and use FTP to get the files back and forth.

I've been using Version control in its various incarnations since 4.x and haven't seen this behaviour. Or perhaps only under one specific circumstance... Are you mixing development projects into a single VERSION project? One nice feature of the latest Version Control is the ability to easily support...

I don't remember all of the gory details (it's been awhile since I last played in this particular sandbox) but I do remember that I didn't have all that much luck working with DSGetNewestLogId. Like Tony mentions, it seemed kind of 'backwards' from the way I wanted to work the information. If I get ...

Well, here's what I've done Tony - hope this helps. First get the start time of the job/sequence that you want the current log entries for by using DSJ.JOBSTARTTIMESTAMP with DSGetJobInfo. Then you can call DSGetLogSummary, pass this in as the start time and use something like "9999-12-31" as the en...

Nope, sorry. The OP has it correct, this setting only applies to new jobs added to the Project. You'd need to understand the underlying structures and write some code to update the Auto Purge information in old jobs. Luckily, I believe you'll find that someone out there has already written a little ...

Check this post for information regarding turning on debug mode to see why the service is not starting. You'll need to translate all references of 'dsrpcd' to 'unirpcd', but everything else should apply.

That's one approach. There's always more than one way to skin a cat here. You could also build a generic routine to get a Link Row Count from a job and call that in your Sequencer, then branch on a 0 or >0 row count being returned from it. You can also build the User Status setting into the original...

Which is why we've been pushing it as "the answer", Siddharth. While it would be great if there was some sort of automagic end-of-data detector built into the Transformers, there isn't. And there insn't a way to slip an extra row under the rug from inside one either. Union. Union. Union! Dang, start...

There's all kinds of ways to do what you need. You can use the Date() and Time() functions seperately and build an appropriate timestamp from that. You could also check out the TimeDate() function to get everything all at once. In either case, use some of the 'normal' techniques to take them apart a...

But of course! Do a search of the Forum for the DSSetParam function, which is what you need - you'll find all kinds of help here already on that particular subject. There's more to it than that, but that should get you started. Give it a shot and then post back when you have more specific questions....

You might want to post your code so you can get specific help. But, as a general comment, after you attach to the job you can call DSPrepareJob before you run it and that will reset the job if it needs it.

No, it is "defined by DataStage" - an internal sort specific to the product. This makes it easier to use and have more options than a UNIX sort, but also means it generally runs slower. You can certainly use the UNIX sort command in conjunction with DataStage or any other external sorting program l...

Welcome aboard, Hubert! :D You've asked one of the questions that has been answered here many times. Try searching the forum for dsjob as it is the command that allows external schedulers (like Control M, which we use) to launch DataStage jobs. You can find example scripts here that people have post...