DSXchange

Well... if the server doesn't start, you won't have much connecting from the client.

It sounds like your install may not have completed cleanly if bits are missing. Were there any errors or messages when you installed the server? Can you try a reinstall?

So it does! Does that mean we get an OCI10 stage? Guess not... to quote: "The Oracle OCI 9i server-side plug-in has been renamed to 'Oracle OCI' as it nows support Oracle 10g."

I doubt it. Don't remember that even being mentioned as part of 7.5. Have you tried pointing DataStage's $ORACLE_HOME environment variable to a 9i client and then using the 9i client via an OCI9 stage to access the 10g database? Does that work? It's an old trick I've used before when 9i was brand ne...

Can I ignore the single tick marks rather than replace them? No, not per se. What we're trying to get you to is a format that Informix will like for loading. You will end up replacing the single tick with two or three ticks, whichever allows the data to be loaded without error. What you'll end up w...

Define the field in DataStage as a 'Timestamp' and you won't lose the time portion.

Each job has a 'User Status' area associated with it. You can 'park' information there and it is available to any other process after that... at least until the job is rerun or recompiled. A Sequencer job can 'automatically' pick up information from there and bring it into a job as a parameter, it w...

I wouldn't get too crazy with your Project names.

Keep them simple and meaningful. I'd suggest avoiding any 'special' characters even if they are 'supported'. Haven't had any issues using dashes or underscores in names that I recall.

The built-in routines are not 'visible' across all projects, they are installed in all projects be default at the time they are created from the 'Template' project. Unfortunately, the answer to your question is no - there is no such thing as global routines. To the best of my knowledge, you need to ...

There was a discussion recently on ADN on this very subject. Oracle numbers are 38 unless specified as something smaller. If you have access to that site, then here is a link to the thread. Long story short, in spite of the numbers actually being 38 you need to declare them as '40' to stop the trunc...

I can think of a few ways myself including passing the last extract date time as a parameter to each job that performs an extract Peter, don't know about the 'bright spark' bit or if this is really the 'best way' to do it, but I've recently done exactly this and used the methodology quoted above. B...

I'm not anywhere where I can confirm this, but I just went through something that seems similar... There is no Oracle 9 support in the Bulk Load stage. In the 7.0.1 version at least, the Bulk Loader stage is "old" and needs components from Oracle 8i installed - perhaps things are different in the 7....

Couple of questions for you -

Is the Oracle database you are trying to automatically load co-resident with the DataStage server?

What version of Oracle?

What database and exactly how are you 'loading' it? The answer to your question could vary based on that information. Something to try: use the Ereplace function mentioned earlier to replace all single quotes with three single quotes - in essence quoting the quotes so they don't upset your load: Ere...

Clarify something - you had a problem actually reading this in using the Sequential stage or a problem loading it into your target table? The single quotes should just be treated like data when reading something like that in where you've got pipes as delimiters and double-quotes for your text string...

Nothing new in the way of 'scheduling' that I recall. However, you seem to be (in other posts) looking for new features in Sequencer jobs, so in case that's what you meant - Some highlights from the pdf: "Substantial Job Sequencer Enhancements" * New checkpoing, Re-start option for Sequences * Loopi...