DSXchange

You can edit your own post, you know. You need to get the separators in the input so it knows it is a time. I thought it was interpreting it as the number of seconds past midnight, but changing the input to 170001 got me 09:00:00 not 08:00:01 so not sure what's going on. If you break up your field w...

Will increasing the arrary size mean that some records could be missed for an update because they both come through in the same chunk of records? Or is each record written to the hash file and available immediately for reference regardless of the array size used in the database? The latter. The has...

That's not possible via the DataStage Director, which leverages cron behind the scenes on a UNIX server. Perhaps an Enterprise Scheduler could be setup like that. Another approach is to build a job control 'wrapper' and schedule that. The wrapper would be responsible for running the other job in a l...

Suggest you do an Exact Match Search for your error phrase - Square root of a negative number - and you'll see that you are not alone.

XML stage? Sun Solaris?

What you want to do is perfectly valid. Doesn't really answer the question if you'll have issues or not, however.

Well... 4.2 is pretty old so I don't remember all the gory details about how it worked back then. Explain what 'not working' means. What SQL does the stage generate, what errors do you get, etc.

I'm not sure what you mean by 'Transactional' stages? Is that a section label of the PX pallete? If they are present in the pallete, they should be in the online help. You can also drag one onto the canvas, open it and then click on the Help button inside the stage. Can you give us some actual names...

Also the status of all jobs are included using the 'Include job status in email' tab What you get with that option is the status of all jobs run up to (and including) the failed job that triggered it. The failed job will typically be the last one listed in the body of the email... pretty much exact...

You should be able to set the Link Tracing Level back to zero as that wouldn't have been involved in making it work. Unless you like the extra information it logs each run of course...

Well, from using the RTI/SOA Edition I can tell you that TX jobs are valid for it to handle. However, I'm not sure you can install everything on one server. And you haven't mentioned what you are using on the RTI Agent side of the equation - WebSphere, Web Logic, etc? And how did you setup and confi...

Have you tried enabling the 'Omit' option?

castor.troy81 wrote:One complete set of 80 questions would be more helpful.

I think technically that would be more like... cheating.

Ok... did you look at what that transform actually says that it does? First problem is the fact that it expects a Timestamp meaning something in "YYYY-MM-DD HH24:MI:SS" format. Second problem is your date would be returned in Internal Date format, not exactly what you were looking for. Not knowing e...

I've seen duplicate replies, but it is rare. Sometimes it is the result of impatience, what you referred to as 'double-clicking'. There have been times when I've been blessed with double or even triple replies when the site is especially slow or acting up through no fault of my own. And you may not ...

Double-check your work. If it works some of the time, then it's not a transactional problem and you should be able to make it work all the time. Check the format of the time portion that makes it into the database. Make sure you are providing that same format to the lookup and that everything matche...