DSXchange

Nope, just that.

You can connect to whatever instances are defined in your server's tnsnames.ora file. If you need more, add them, usually by enlisting the aid of your DBA to do that for you.

You can, and how you do that is discussed in the Planning, Installation and Configuration Guide pdf that ships with 8.

I agree. Much more better now. :D

You seem to be confusing the 'final' delimiter with the 'record' delimiter.

:idea: Tip: you can use the 'code' tags to preserve white-space and make things line up. You'll need to make liberal use of the 'Preview' option as well as it doesn't always work like you think it will with a proportional font. And one can always edit one's own posts so it's not too late to go back ...

You also have an odd combination of single and double-quotes in there and I think a mismatch is tripping you up.

As noted, the command line dsjob function has a -run reset option you should be able to leverage for this.

And if you can't figure out the 'precision and scale' part, go all Old School on it and divide it by 100.

Why, that's elemental my dear Watson, when you need to override it, set it to a non-default value. As already noted. Thrice now, I believe. And that's not called a default value for no reason.

Sainath.Srinivasan wrote:DataStage is not a Time Machine to send you back one year.

Too bad, always wanted one.

Note : I did not change the metadata and this job is designed last week and upto yesterday it's working fine but today i am getting this error What changed between then and now? The job? The Oracle table? Something obviously did, the problem is going to be figuring out what. I would suspect the lat...

What stage are you using? What does the documentation for that stage list as unsupported data types and/or as 'issues' for the stage?

Well, at least we have a Clue now.

Ray has made available a generic IsValid routine to validate most data types, a search should turn up the link or perhaps he'll stop by and post it again. You can also use IConv() then Status() to check to see if it was able to convert it. :!: Be aware, however, that just checking for 'valid' might ...