DSXchange

I'm guessing that the two 'roots' refer to installing the software to two different folders off of root. And while you can do this, why in the world would you want to go to the trouble? There is a pdf document in your Docs directory that explains how to install more than one version at the same time...

Not really worth explaining... just wondering if you missed one question on purpose to make you seem more... human.

Your use of the pound/hash signs is confusing people, as they are typically only used in conjunction with job parameters. Or are you saying that the command stage is generating that syntax? I'm as blind as most people here, never having worked on a Windows install of DataStage and thus never having ...

One option is to use a 'Distribution List' - one email address where the email automagically gets sent to several people. Otherwise, the actual delimiter needed can change from system to system, so first thing to try is either a space or a comma. And when you try the comma, make sure there is no spa...

ray.wurlod wrote:I did get one wrong in the certification exam, if that's any consolation.

On purpose?

Perhaps... but no, I'm not using a -wait when resetting and never had a problem since adding the sleep. [shrug]

??

Ok, now I see - the subject of this post is "Thnx". FYI- people can only see that when they reply so it's not really an effective technique. And please, you don't need to quote the whole dang message just to say 'Thanks'.

The original version was all command line driven, having to execute a batch file to switch things. Once they 'improved' it and made it a service, that option went out the window. What about using one of the many 'macro recording' utilities that record and 'play back' a series of mouse clicks and key...

Doesn't really matter what your query is, you've used user-defined sql and it is not syntactically correct. Fix it.

Perhaps the array size referenced here is for your transfer buffer to/from the database. Yes, this looks like some sort of custom algorithm used to set the Array Size option in a database stage, specifically the DRS stage from the comments. Nothing to do with BASIC arrays but that passive stage opt...

Who said anything about an SFTP stage?

I'm assuming this will need to be scripted and you'll need the proper RSA keys / authentication in place so it can happen in an automated fashion.

When he said RTI/WISD was required to expose an ETL job as a service, he means you'll need to purchase that optional component. If all you are doing is calling a service, then you've got what you need.

Perhaps this post would help:

http://www.dsxchange.com/viewtopic.php?t=111013

There are many more on the same subject.

You might want to clear up exactly what your question is, you've gotten two responses from two different camps. Is this a design question - adding large numbers of parameters to jobs - or a runtime question?

Hmmm... I just reread what you are doing to force the problem to happen: Do the following: Pick a category which has lots of jobs (simply to get the print to take a while) Click on project>print>Select the print to file Click OK While it is printing, select a different category and then reselect the...