DSXchange

Secondly every job makes some intermediate files is there ay wayt o remove those files automatically. e.g. when i go and check the project folder i see some files with the names of the links names. Some points if you are seeing files with link names in a project directory... 1) Object names should ...

Search the forum for exactnumeric and you'll see what's going on. 15 is the default max precision allowed.

A routine would work quite nicely in that regard, depending on what you need to do with the information. In any case, seach on DSGetLinkInfo for a way to query a completed job for the number of rows that went down any given link.

I remember working through that issue with you, Phil. And a good time was had by all.

WoMaWil wrote:yes

Ok, Wo... I'll bite. Yes... you've solved the issue? Found that it works in 7.5.x? There is a pressing reason it needs to be xml? You are just in an agreeable mood today?

Generic solution - sort descending by upc sold. A job parameter for the threshold can then pull the first X records out of the stream afterwards via a constraint as the 'top X'... unless you need to worry about ties. In that case stage variables could be employed to check for changes and increment o...

Guinea pigs, eh?

Pretty much all the way, actually.

The error tells you exactly what's wrong and even drops some pretty broad hints on how to fix it. Check your installation docs. There will be instructions on configuring DataStage to use Oracle which involve, amongst other things, making sure your $ORACLE_HOME libraries are in your LD_LIBRARY_PATH. ...

It is a very odd and (luckily) fairly rare bug. Not related to having the job open in the Designer, because if you did the Initialize/Promote step would fail as the job is locked. Heck, even monitoring the job in Director will cause it to not have 'exclusive access' to the job executable. When this ...

Nope, this doesnt work when I delete directly from the VC project. 'Course not. You are asking for trouble going under the covers and deleting jobs 'from the project' without using the GUI as the control tables VC relies upon will be out of sync afterwards. Simple enough to delete via the interface...

Because you haven't installed it yet. It (Version Control) automatically installs into the same directory your client software is installed in and then the docs show up on the same menu as well after that.

Are you trying to insert into a CLOB or select the contents one? And I'm assuming you are only having problems because you are dealing with more than 4K of data in the field, yes?

No, but you can do attachments.

Sure... it's just that you've more than likely got tons of crap warning messages that there's no reason to keep once you see them. Change your refresh interval in the Director to its maximum. Open the Log View on a job you can access. Set the filter to show a small number of records as already sugge...

I suspect that transforms may only be used from within transformer stages. Your suspicions are correct. It's just a snippet of derivation code that's substituted in by the compiler at compile time. Snassimr, open up the transform and use that snippet in your routine... follow the DEFFUN advice that...