DSXchange

ray.wurlod wrote:I also have UniVerse and Red Brick hats. See my web site.

I know... just figured you wore them all at the same time.

Yup, FD is File Definition or File Description, take your pick. In all the years I did COBOL I don't recall ever seeing notation like someone gave you - unless they though it was all you needed. Suggest you go back to your source and ask for the FD, they should know what it is and be able to supply ...

Umm... yah. Answered this question over on developerWorks and then come here and find you've all copied me. Fine, be that way.

There are weeks when you don't wear your DataStage hat? [/boggle] Say it ain't so! Never really played much with the CFF stage or I'd give it a shot. Would have been nice to get a proper COBOL FD posted. Just4, no-one gave you anything with levels and proper COBOL field definitions in it? Anything g...

The issues aren't with the OCI stage, it's with multiple actions in user-defined sql... IMHO that's a bad path to be walking down and the DRS stage just makes the slope a little more slippery by allowing stuff like that. Learn how to build robust jobs - native stages, separate links for inserts v. u...

Ray, a perfect understanding of the question and a perfect response that's what I can appreciate. So say we all. Nothing like shooting for the moon in your first thread here, however. I would think you would need to start with the perfect question before you could see perfect understanding and rece...

While it should work fine, I'm not a big fan of the DRS stage so I don't use it and can't say what kind of an influence it might have on your rejection handling. Unless you've got a wonderful reason for using it, I'd really suggest sticking the OCI stages for Oracle. I prefer REJECTEDCODE, so if tha...

How exactly? Post your constraint derivation here directly from the job, please don't hand type it. Or is that it? Specifically... Is your database link called VALID_LINK and what you posted is the constraint from a separate 'reject' link you setup? Also let us know what database and stage you are u...

How are you capturing rejects? There's all kinds of different methods, you'd need to explain exactly how yours is setup before anyone could comment on your issue.

If they need specifics - meaning what information the application uses those select grants to get and how the Enterrprise stage uses that information - you'll need to contact Support for the gory details. Unless someone here knows or it's documented somewhere.

http://www.filefactory.com/file/6c4352/ JOB http://www.filefactory.com/file/e80491/ Header file http://www.filefactory.com/file/efac75/ No Header file Do these links work for anyone? All I get are a bunch of crappy pop-ups and the File Factory homepage. If I need to register there just to view them...

1. Because they are required by the application. What other answer were you looking for? Without them it will not function. We're only talking SELECT privs here, nothing scary and I'm guessing most places would assign those grants to a specific role and then grant your Oracle user that role. 2. Yes.

How about some details? You haven't shown us exactly how you are using this environment variable in your job nor the compilation error. Why not post both, then perhaps people can stop guessing what your issue might be.

Well... it's certain not supposed to work that way unless you specify one of the following options: -wait -jobstatus -userstatus Otherwise, it should start the job and exit. If you are certain you are seeing this behaviour and you are not using one of the above options with your dsjob command, I'd s...

This seems like a change in behaviour to me, but perhaps I'm just wrong. Currently, when you are on a later page of a multi page thread, the replies shown below where you compose your reply only go back to the earliest reply on the current page. I could have sworn it used to go back to the first pos...