DSXchange

Start by doing an exact search for a unique part of your error message... I just used "either the directory containing the library file" and got almost 100 matches where people have posted the same error. I would suggest working through them, starting with the ones marked as Resolved.

ffsw13 wrote:I guess I could add it so I can run the command from anywhere without the fully qualified path yes?

Correct! :D

First guess? You're not running it from the directory in which it lives.

Once again, splitting you off from a vaguely related topic to one of your own. Maybe just start with a new one next time.

Can you show us the syntax of the function you used in your job?

We'll need a better explanation than that to really be able to help, I'm afraid. Can you post some actual examples of the strings you need to search? For example, I'm unclear if what you are looking for is a total match or a substring match. Also unclear if you need to check all six at once and retu...

Not that I've ever seen or heard of... but others might know.

Please fix your signature.

[Note: Signature corrected to use tags instead of html - Andy]

Was thinking the same thing, Ray. Other than that one error message, there is no other message related to this. Other than what 'one error message'? The one from the SQL trace? So you are saying that your Director log for the job shows no error messages and completes without warnings or errors but i...

The only caveat with vi on a UNIX machine is the size of tmp, which can be a limiting factor. Plus you have to be conversant in vi which I find more and more to be only something us old folks know and love.

johnboy3 wrote:maybe I can follow his "feed" if he has one

I don't think the site has had much (if any) activity in recent years but that's doesn't mean the routines there are no longer useful.

Okay, that would have been good to mention right off the bat. So what was there in the Director log? You can see both what I used to call 'hard' and 'soft' rejects from Oracle - hard/physical where the database barfs it back up after you send it down the link and soft/logical when DataStage knows so...

Karel - first off, welcome. :D

I decided to split your issue off into its own post and link you back to the original but in doing so had to guess at your particulars - Release & OS specifically. If either of those are incorrect, please feel free to go back to the first post and edit it. Thanks.

Yeah, never was a fan of any kind of 'SQL Builder' option.

splayer wrote:In the last run, it suddenly started giving ora-01438.

ORA-01438: value larger than specified precision allowed for this column

Guessing it's your data that changed and now overflows the target.