DSXchange

Can't help with the error, suggest you call Support and see what they have to say. For the record, what binding methods did you purchase and which one are you using? On the second scenario, keep in mind a 'limitation' of using Sequential files in RTI jobs, especially 'always on' ones - the file is n...

'SP2' as in Service Pack 2 for Windows... that's what causes the issue. FYI.

If the jobs are initiated from a sequence they are tied together so job.a crashing (or being stopped) cascades the stop down the tree. I'm in the same boat as Arnd (no pun intended) - I don't quite get this as this is only true if you've set the Sequence job up to make that happen. Usually via the ...

The 'other' thread seems to be about select performance, while this one is insert/update related. I think I'll stay here. Dollars to doughnuts, I'll bet it's all about Oracle and how you have it setup -and- how you are leveraging it. While inserts can suffer the same fate, what typically 'goes down'...

Dang, and I was just about to push the Submit button here. [sigh] Ok.

As noted, it would have been nice to know what 'the database' is that you are referring to. If you are asking if something like an Oracle database, let's say, needs to be installed on the same server as DataStage to be accessable by it - heck no. That would be one heck of a limitation in the product...

The only difference being a soft mount was used for the server instead of a hard mount. Hmm... when you say 'for the server' do you mean where you installed DataStage? If so, I was under the impression it wouldn't even allow something like that. If not that, then curious what you really meant by th...

Kim and I and a bunch of other Fine Folks were in the very first Transition class... lovingly referred to as the Guinea Pig class. It was well worth the time, quite well done and interesting to boot helping work out the minor kinks in it. :D

Cheers!

By 'unreadable' do you mean EBCDIC or perhaps packed decimal fields like COMP-3? If that's the case, why not use the CFF stage to read it? And if you don't have the metadata for the file - get it. You'll be on a wild goose chase without it. If you really want to read each field as a record, you'll ...

Hmm... don't really know as I haven't tried to marry DataStage with Oracle 'object' datatypes like this one yet. Are you trying to select it, update it, insert it? In other words, wondering where you need help. Usually, there are packages or functions defined for this... let's see... looks like SDO_...

Yah... Arnd just aced that one in the interview, I'd bet.

The issue I had when setting up RTI input with XML input is assigning a source column in the XML input stage which looks like a mandatory option. Treat it just like a Folder stage but without the ability to pass a filename - only the contents of the XML sent to it. So (typically) a single LongVarch...

Rajender wrote:As such was wondering whether someone have the code for the routine JobReport

As stated in the other thread - no. Ascential specifically released it without source code. That being said, you don't need it.

Sheesh... rather than process all three hundred in a singleton fashion, could you not concatenate them all together and process one file?