DSXchange

You haven't configured your system properly for the stage to be able to use Oracle as a target, it would seem. Read up on that subject in either the Plug-In Configuration Guide or any document for the DRS stage itself.

Thibal wrote:About my "cleanliness" issues, I'll find tips when developing (It's a pity it doesn't exist a kind of Sequence Container)

Actually, there is! It's called another Sequence job.

No, that's not the problem. If you search the forum for either the error in question or the phrase 'timed out while waiting for event' you'll see it's a resource issue. You are asking too much of your system, spooling up more jobs that it can handle. There is a hard coded value deep in the engine of...

Header file? Experience. You could go through the included routines and see which ones include which headers and try to figure out why. You could also find the header files under your DSEngine directory and examine them there. You'll be able to tell from what's defined in them when you would need to...

Pretty sure this is all documented in the Administrator Guide pdf installed along with the client software.

Dsnew - nothing gets ignored here. You write Routines via the Manager client tool. When your cursor is over in the Routine branch of the repository, the File menu will give you the option to create a New Server Routine. You can also copy an existing one and edit it much the same way you would do tha...

Trigger, smigger. Why take the sissy way out?

output is an .csv file but when i open in wordpad i found 3 double quotes synbols instead of one double quotes symbols..why? More than likely because you have quote delimited string fields in the file with quotes in the field. Then you have to 'quote the quote' in order for it to not confuse things...

You never actually said anything about it generating an error. I just got the impression that your output wasn't quite what you expected. I'm still not clear on exactly what you are expecting as output. Are the double-quotes supposed to actually be in the field when all is said and done? If that's t...

Reread my previous post and ensure that you have the same number of columns defined in the stage as you do parameter markers. You don't need to provide any 'dummy value' for the surrogate key in the job itself, but you will need to use User Defined SQL in order to add the 'nextval' into the insert s...

No, I do not believe that you need to rerun the job after one of these problems crops up.

Finally decided to throw my two cents in the ring on this. I work with about a dozen other developers right now and I'd say that I am the only one out of them that is comfortable writing my own 'Job Control' code. Experience definitely colors that picture. I haven't been using the product since Vers...

I did a quick search for 'all terms' of curwave lastwave and got 12 hits, couting yours. Picked this one at random and it seemed like one of the normal Ray To The Rescue posts you'll find on pretty much any subject around here. Try the search yourself and check out the other answers if you like as w...

That's good because - in Arnd's own subtle way - he was saying that there was not nearly enough information in your post for anyone to help you. Other than acknowledging that they have seen things like that before, of course.

When you are working inside the Derivation editor, there is an 'ellipsis' or three little dots like this (...) that you can click on for help building expressions. One of the operators it offers you is concatenation and in DataStage the concatenation operator is the colon or ':' sign. You build up c...