DSXchange

Yes, substring. Hack off the milliseconds, Oracle can't use them.

Well, at least they've reproduced it. Has it been assigned an eCase?

From what I recall, the 8.1.7.0 client was notoriously buggy. Any chance you can upgrade it to some flavor of 8.1.7.4?

Craig, could you define 'large' please? Not really. Large is a relative term and would vary from system to system. I'm just saying that, once a job has completed, that phantom entry has served its purpose and is no longer required. It is a Good Practice to help keep their numbers under control and ...

Probably a little less risky if you export to an XML file and edit that. And I'd suggest doing the export, making a copy of it and then editing the copy. That way you've got something to fall back on if a subsequent import of the edited file horks things up. Or if you happen to hork it up... not tha...

Well, glad it was a simple fix. Still hoping Ray or Kim or someone will come along and provide you with some Words of Wisdom regarding your situation...

Ugh... I hope you have a backup. You're probably going to need someone like Ray (someone who understands the internals of DataStage) to answer your question. My understanding is that this probably was not a Good Thing to do. From what I remember it will convert all hash files in the engine to 64bit,...

The Num function checks for numeric values. You could simply 'not' it:

Did you find this thread? On the subject of searching pdfs, Acrobat has the ability to search through more than one pdf at a time. There is an option to 'Search all PDF documents in the following folder', all you need to do it point it to where your DataStage documentation is and you should be set. ...

Well, the only 'restriction' I am aware of is the fact that the root directory of any drive is the only one with a limit to the number of entries it can contain. Don't recall the actual number, and this may be a thing of the past, but it certainly was an issue Back In The Day. Besides, as Ray mentio...

Mutt is a great little tool to add additional functionality to your email, but you don't need anything 'extra' to send email. DataStage comes with hooks to standard UNIX email and should be leveraging sendmail on your platform.

I'm a little lost in what you are saying, but keep in mind the fact that the ODBC and OCI stages are configured separately and that one has no idea what you've setup for the other.

Might help to know what errors you are seeing. Also would help to wait for the job to finish before you check its status.

My current client would like to know how you implement this. Please? Really? Morney has posted quite a bit of the gory detail, but it really just boils down to sending a short email to a text message enabled pager or cell phone. For example, here I would simply send an email to my 10 digit phone nu...

Because DataStage has no clue that the functions you are trying to call are job control functions. Without you helping out, it thinks they are variables that you have never declared, i.e. never 'dimensioned'. Add this to the top of the routine: $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $E...

What Oracle client are you using with DataStage? I guess for a Windows server, the correct question would be - which Client is your default home? Also, are you using a Transformer between the stages you are indicating? Best Practice says you should always use an Active stage (like the Transformer) t...