DSXchange

Nothing. Use something else to view the 'complete content', like say XMLSpy or others of that ilk.

See, here we are all nice and moved. Thank you Mr Roy. First off, each O/S has "a" shared library path and it's either SHLIB_PATH *or* LD_LIBRARY_PATH, never both. For H-PUX it's the former so the LD_ line(s) can be removed so as to not confuse the issue. HP-UX B.11.23 - doesn't that mean you're sit...

You haven't explained what your output needs to look like nor what the 'lead' function does. Not everyone here is fluent in Oracle and your 'problem' is unclear.

Apparently. Probably a problem with your 'x2' version, I would guess. [shrug]

Hmmm... There's a checkbox on the first page of the Wizard to 'Compile Custom Server Routines' but you don't seem to need to enable it. I just simply (and only) check the 'Show Manual Selection page' then click Next. Under Project Contents you'll find Jobs, Custom Server Routines and Custom Parallel...

Part of the BCI or Basic Call Interface. Pick one term and search the forums, all kinds of things you've never wanted to know will be revealed. Or download the manual from IBM's website.

Define 'join' in this context. Actually - spell out in words for us (and you) exactly what you need to do with the header and trailer records. Without using the word 'join'.

First suggestion would be to search the forums for jobmonapp and see if anything you find from that helps.

You can't , only the Moderator can, which is what Ray requested. Question: have you tried to configure the Server environment for Oracle at all? This is all documented in the pdfs you have, but basically you need to do two things, both accomplished by editing the $DSHOME/dsenv file. 1. Make sure th...

'Real' job update date/time? Depending on what that means, you could query the DS_AUDIT table in the repository for that I would think.

If you always get two digit months and day, then you can substring it apart and put it back together however you please. Otherwise, standard IConv/OConv pairs will do the trick.

I've not had to worry about that large of a CLOB before, everything we have fits well under the package's 32K limit. Sorry I couldn't help.

In job? Aggregator. Another approach is to gather this 'after job', using DSGetLinkInfo, either in the After Job portion of the current job or a generic trailing (seperate) job that just performs this function.

Suddenly stopped working? Never worked? All jobs have this problem or just certain jobs? Details, man, details!

Yah, CLOBs are painful and not supported but we've been able to make them work in Server. If you are on 10g you can try using something that helped us alot, the DBMS_LOB package. Specifically, I recall a 'sub string' function there that allows you to pull a large string out of the CLOB without upset...