DSXchange

Been revisiting the Web Services Transformer stage and thus trying to import the metadata from a new service currently in developement. The subject is the error we get when attempting to do so from the wsdl provided. Don't really get anything more useful from the error message itself. After that, I'...

I've never had a problem with that function. Some questions...

* What exact Oracle client version?
* How did you verify the 'original data' is 4000 bytes?
* Does your query 'work' in your tool of choice, Toad for example?
* How did you get both outputs into Word for these counts?

Stage variable - start it at 1 and increment until you hit the first day of the next quarter, where you reset it back to 1.

Good, one down. What did you find when you searched the forum for your new error message? It's been discussed quite a number of times...

"Controller problem: Unhandled failure"

Hi friends, i cant use aggregator stage as i'm having five different branches so it'l give five branch details as i'm gouping by branch id. but i need only the branch with which is most profitable alone. And also i cant use sorting and get the first data alone as there wil be a problem if two branc...

Why the script returns _(underscore) when called from Datastage and not from Linux is beyond me. [sigh] Classic 'why does it work when *I* run it and not when DataStage does?' problem. I'd wager 400 Quatloos on the answer being one of our standard caveats when writing scripts not being followed - A...

Welcome Aboard. :D That's something you'll need to code in yourself and depending on when you enforce the %, you may need to know the total number of record you will be processing as well. Do you 'need' to stop things immediately when it hits 40%? Pass the total in as a parameter and check as you go...

njgirl wrote:I have tried substacting the two dates directly, but it retuned only 0 values.

If you are referring to my first sentence, that applied strictly to your Oracle query:

First thing, you are aware that you could simply subtract the two DATE fields when selecting them from Oracle and get the number of days that way, yes? However, it is straight-forward in DataStage as well. Rather than just hand you corrected code, let me give you a hint instead. You are on the right...

Welcome aboard. Did you perhaps mean you get output as 'B'?

I am right. You really should use DSSendMail directly, not the 'Tester' version which just wrappers it. Build your own wrapper. You can ignore the 'were not mentioned' part as that's normal for sendmail. Search the forums for INTERIMSTATUS. It is a check you'll need to make in your routine to see wh...

Right. With that option unchecked, it will always run the after-job routine. Checked, it will only run when there are no errors in the job.

From $DSHOME/include/dsapi.h - /* 'jobStatus' values... */ #define DSJS_RUNNING 0 /* Job running */ #define DSJS_RUNOK 1 /* Job finished a normal run with no warnings */ #define DSJS_RUNWARN 2 /* Job finished a normal run with warnings */ #define DSJS_RUNFAILED 3 /* Job finished a normal run with a ...

Stop letting the database truncate the data for you, do it yourself in the job. Substring off only the first 10 characters and move that into the smaller field.

I don't know why you'd need to call a function like this directly. Why not explain what exactly it is you are trying to accomplish and what issues seem to be standing in your way?