DSXchange

As said by ArndW, you can come to know the Job no by LIST command as well,


Please correct the SQL, ArndW.

Correct chulett. So... your question was some kind of a quiz? What the frak was the point of that? :evil: If you knew the answer, just post it as a clarification. If you didn't, say "Thanks" and move on. I didnt know the answer before. So I just did what you told me to do. Everything happ...

kduke, I initially searched a good answer for the questions i raised when replying to your initial post but unfortunately they seem to be not found. Your exposure in UniVerse and tactics in DataStage upgradation look good as expected as you are always, and there is a known statement that you were al...

ArndW, I immensely request you not to delibrately take my first or further posts as a piece of advice to the man who knows how to smell the goodness of each cell in all the way as being with UniVerse more than twenty years. We(especilaly, I) contribute my whole respect to you for being an expert in ...

ArndW, 1. Would you like to let me correct myself the SQL i gave if i just intended to italic the job name in the code section. 2. Did you note that chulett has also recommended that way? Was he also wrong recommending to use undocumented tables? 3. Would you like to advise me where to look at Job n...

Correct chulett.

The Job no of a particular Job is changed only when the Job which has same Job name, gets imported into that project.

Author - you may use this SQL

chulett - I do pose a query regarding your statement, though which seems to be offtopic. ...which can change over the lifetime of the job. I am very keen to have a clarification for this statement. What causes the Job no changed over the lifetime of Job and how it happens internally? Please clarify ...

But I am unable to connect.

What DataStage tells you as error message?

ArndW, The question you just bring in, could be the first question from you in this thread as doubting that how this solution would be a comfortable method of doing back up and restore process to a lay man who does not care about the DataStage internals at any point of time. The underlying statement...

kduke, Thanks for your comments. I have been using Universe since 1986 and I would never do any of this Here and now my first question would be 'Could you provide me any valid reason for the question that why didn't you involve yourself in these UniVerse commandsin your more than 20 years of experie...

Thanks chulett and ray.wurlod for sharing your personal preference.

would you allow me to take a chance to complete your statement with pleasure as -

"Most of the disk space used in Server jobs is in the project directory, unless the developers have chosen another path in the target file Stages."

You are entitled to your opinion. I, on the other hand, rejoice in having a sense of humour. Let me render a high respect to you by having given a humorous gesture. And would like to ask you a question - Would be able to provide a valid reason for my statements being consiered as superfluous since ...

OK ArndW, Not true in this case because all the RT_xxxnnn hashed files share common file dictionaries. Because the dictionary name does not correspond to the VOC entry name, the VOC entry is not deleted, instead the data file pathname (field #2) is set to nothing, as per the message. These entries w...

Most of the disk space used in Server jobs is in the project directory I still do pose one more query for a better understanding of your Statement as it seems to be new to me here. [I am not afraid to create a new thread, though] 1. If the disk space occupied by Server Job is not mainly concerned w...