DSXchange

Is a string sort acceptable for that data? If so, you should be able to leave the field as a string and override the default Aggregator behavior that converts everything to double in the stage. There should be a 'Preserve Type' option in there somewhere that will accomplish that.

Sure, you can certainly convert character data to numeric, that's what functions like StringToDecimal() are for. HOWEVER, it must be convertible - something '23 xyz' is not, if that's behind the question being asked.

So... you are looking for the software? Guessing so from the 'or', this rather than looking for help installing the software that you already have. Yes?

Yes.

You could write a custom routine, use the API to check the status of the status of the job in question and then do whatever seems appropriate should it be running. Sleep, check again... repeat as needed. Use a routine activity stage before the job that may need to wait.

Continue to use the 10g client to access the 11g database, you should be fine. Vice versa? Not so much.

You could do that. I assume you are talking about a new Sequence job here, you could also simply incorporate these four Routine stages into the existing "fifth Sequence". In either case you would have them run first, with all four trigger links going to a Sequencer set to "All" a...

We wish!

Seems like we need a big stickied post somewhere directing people with this popular request to Kim's site.

Wowzers Andy, didn't know you had such powers.

Thanks!

It's always 'back'... as noted sometimes I kill them before you see them, sometimes they survive long enough (say, overnight) for people to notice. Not quite sure what's going on with Dennis lately, no reply or help shutting this stupid thing down. :? Problem is, without a better (bot-resistant) reg...

Or just one. I for one see no need for this to be any kind of 'generic' routine that you call four times. In your shoes I would have one dedicated routine that (one after the other) checks all four by name and then decides what to pass back based on the result. Did all four run successfully? Pass ba...

You set the Read Mode property to PL/SQL (this rather than 'Select') and then put your anonymous block of code in the Connector where you would otherwise have a SQL select. While there's no specific examples there is plenty of discussion on how to use PL/SQL in the connector to either read from or w...

Hey - Lance!

What Andy said.

What exact version are you on?