DSXchange

pravin1581 wrote:How can we run the SQL on a file ?

Or simply load your file into a 'work' table in your database of choice.

It does whatever you tell it to do. The Sequence only cares if the jobs it runs have problems if you make it care. That means triggers, the Exception Handler or the 'Automatically handle' option that DSGuru mentioned. Or all of the above. Unless you want to define exactly what happens, check the opt...

We're not here to paste entire manuals into posts for people. Nor are we a substitute for proper training or for 'from scratch' education. If you've got specific questions or problems, please let us know and we'd be glad to help. Search the forum first as I doubt anything someone could ask hasn't b...

anisubim wrote:please kindly reply, because i am implementing these steps in my project

Please kindly start your own thread.

Never mind, I see that you did. Anyone motivated to post on this subject needs to find the real thread and add your two cents there.

You would want to contact the webmaster, not the editor. And make sure you let him know your O/S and especially what browser you are using. Use the Contact option at the top of any page.

roy wrote:Guys, Arn't we going off topic a wee bit here

Just a wee bit. Perhaps the moderator could hack these out into a separate thread off in the General forum or some such?

No, don't uninstall anything - just install the 9i client as well. Then you'll need to configure DataStage so that it uses it. I know how to do that for a UNIX server, but not a Windows server.

They are 'header' files, also known as 'include files' for the compiler, much like copy books in a COBOL world if that means anything to you. They live in the $DSHOME/include directory from what I recall. Take a peek, they're just text files and are good to look at. Just don't move them or think abo...

Welcome anisubim - but you really need to start your own post, not jump on the end of someone else's post please. And in your new post, clarify if you mean 'dsjob' the command line function or if you literally mean 'DataStage jobs' in general.

In Version 8 you'll have a nifty utility to do that from what I hear. Right now about all you can do is export both jobs and use a good 'File Compare' utility on the dsx or xml files.

No, not really. Do you actually mean 'wrong job' or wrong version of the job by the way?

You'd have more options if you were on a 7.x version, Sequence jobs support looping constructs there. For your version, I'd look into either hand coded job control if you are comfortable with that, or perhaps a job that reads the parameter file/table and leverages the UtilityRunJob function inside t...

Only if that's something recorded in the DS_AUDIT table and I'm not sure if it is off the top of my head. Do an Exact match search of the site for DS_AUDIT, one of the existing posts should answer your question I would think.

Interesting... any idea if there is a 'down side' to enabling this in a RAC environment? Or is it simply a requirement for the RAC users of the world?

Probably not the best place for this, smack in the middle of dsnathan's post, but oh well... I agree you can't just throw a numerical yardstick against a poster to determine who is 'top'. A spambot could be a Top Poster. If it was just about the numbers we should all just hang it up and grovel at Ra...