DSXchange

...and what order are your links in?

Actually, it's probably more an example of not using fully qualified table names. If the table is not qualified, the assumption is the current user owns it unless synonyms are involved. So you do the import as one user and connect as another and all you get for your trouble is 'Table or View does no...

O. M. G.

That would perform a Horizontal Pivot, basically the exact opposite of what the OP needs to do.

Exactly. All of that is spelled out in the pdf manuals that ship with the product. I don't recall off the top of my head which exact one it is, but there is one that walks you through building Sequencer jobs and all of the stages one by one. Check it out.

I have a doubt, too.

bala_135 wrote:Set the project properties(ie inside the repository) only read

Please explain exactly what that means, what / how you are setting this. Thanks.

You'll definitely need the Java Pack as far as I know, the question remains if the Java Pack requires SOA or can run without it. I don't know.

Greg, they aren't literally named like that are they? Project1, Project2, etc? Typically, in my experience, you would name projects based on the subject area they serve and they would come in threes as mentioned in the VC docs. Four when you throw in Version Control: SubjectAreaADev SubjectAreaATest...

And when Arnd says 'all hashed files' he means literally all hashed files - not just the ones that are used in your jobs or ones that 'need' it. That means all internal hashed files created by the engine in every project as well. These are the three that Arnd mentions. Not generally something you wa...

Windows XP - Home or Professional? And there *is* a patch to make DataStage compliant with the changes in Service Pack 2 - have you downloaded and tried that? You can find it on Ascential's eServices website.

I believe that only an administrative user like 'dsadm' can delete jobs from a protected project, or are you saying that a regular user can as well?

Seems like it, Arnd. If that's the case, and depending on the uniqueness of that target line... grep to get the '###' line pulled out -or- tail -1 if it is literally the last line cut to get the information between the parens date with the proper mask to get the current day mv to do the actual dirty...

Oh, and everyone gets an "RTI Pallete", it's where the XML stages all live. Doesn't mean you have SOA.

Sorta. That is one of the bindings you can use when you deploy an SOA enabled job, but you have to have purchased that particular binding option. However, that just means that your job is now an EJB Web Service. If you want to call Java "stuff" from inside DataStage jobs, you have to buy the... wait...

I believe so... couldn't hurt to try. It will either work or not work. At worst case, unprotect the project, make the change and then protect it again.