DSXchange

The example helps but is incomplete. You say 'equivalent char' like you want this translated into a single character - but I'm guessing you want this number spelled out in words? If that's the case, Ray posted a routine to do that quite recently. Either one of us could search for it. If that's not t...

This is rather simplest thing to ask. If you have a number in billion then how will you calculate the equivalent character for this decimal. Rather simplest, but I have no idea what you are asking. Can you rephrase or provide an example of what you are trying to convert - from and to, if possible?

I need to get the count from a table. If the count is > 1 as I check in the transformer, then I need to raise a warning for the job level in the transformer. Please let me know if there is any function to do that. No mention of other jobs or anything else at the "same level". Just a question on rai...

If you call this in an after job routine will it know if the job is going to finish with warnings or abort because the other one always shows running? Allegedly. I haven't had a need to try this but remember Uncle Ray mentioning it here. Only issue might be aborts where you checked the 'only run if...

Me thinks the young Padawan means DSLogWarn, DSLogEvent is used to do the equivalent in a different job from the current job.

IE 6, work and home, have not seen the issue that I recall.

There is no reason to need an undo. A 'redo' may be in order, however, if it was run when other users were connected to the project...

Thanks... I do receive Product Alerts for DataStage currently but just added a Platform Alert for our O/S as well. From the site: A provision of the Energy Policy Act of 2005, extends Daylight Saving Time (DST) in the United States by four weeks, beginning in 2007. Systems and applications that proc...

For those of us in the US and needing to deal with the change in Daylight Savings Time start and end times this year - are there any 'DataStage issues' to be aware of? A 'big project' is underway to coordinate this change across the enterprise and I've been pinged for DataStage. Seeing as how we're ...

Have you 'sourced' your dsenv file first? Don't see that in your example. cd $DSHOME . ./dsenv While 'uv' should work, I typically reserve that for starting and stopping things. Have you tried 'uvsh'? Not sure what the difference is, but curious. Technically, 'dssh' should be used nowadays - if that...

Or simply check JOBINTERIMSTATUS rather than JOBSTATUS. From the online help: DSJ.JOBINTERIMSTATUS. Returns the status of a job after it has run all stages and controlled jobs, but before it has attempted to run an after-job subroutine. (Designed to be used by an after-job subroutine to get the stat...

Never worked with the OLEDB stage so can't say if there's anything 'special' needed there. However, to capture reject rows properly from any database stage you must keep your Array Size set to 1. Is that how you've got it configured?

As noted, the Agg stage can't handle that volume unless two things happen: 1) The data is presorted in a manner that supports the aggregation being done. 2) You assert the Sort Order in the stage so it knows you've done this. Get it right and rows will flow through the stage at each 'sort break'. Ge...

I haven't seen this. When you say 'clicking on a link' do you mean the normal navigation links for the site, or links people have posted inside threads? If the latter, I've only seen that when someone is connected to 'dsxchange.com' rather than 'www.dsxchange.com' and they post a link without the 'w...

Nice, thanks for reposting the link. The first link on the page takes you off to the IBM Information Server Information Center where it says: You can find the PDF books for all IBM Information Server product modules on the IBM Information Server PDF CD. Anyone see or know how it can be obtained?