DSXchange

Or a Compare stage. It really depends on the format in which you require your output. The Difference stage won't help, the Compare stage will. The Change Capture stage is more intended to set up a structure for a Change Apply stage to use to re-build the after-image from a before-image, for example ...

Slightly differently-named functions if you prefer to use Modify stages.

Been working on a 7.5.1 site this week, and it is not there.

Maybe it's only available for 7.5x2 - that is, on Windows platforms.

The ODBC Enterprise stage can certainly access SQL Server via the supplied ODBC driver from a UNIX platform - we did exactly that today.

Hi Siva.
Are you thinking of the function in the DataStage BASIC manual, or the DataStage API functions (principally in the Server Job Developer's Guide)? If the latter, there are some examples in on-line help.

The DataStage user ID can not find the executable for sqlldr, the Oracle bulk loader. This in turn means that the PATH environment variable does not include the directory (usually $ORACLE_HOME/bin) in which this executable resides. Check in the dsenv file in the $DSHOME folder.

That error message is telling you that the DSGetJobInfo() function requires two arguments, and that you have not provided an assigned value for the second (InfoType) argument. This occurs at (or near) line number 98 in your routine. It is unrelated to DSPrepareJob().

Your hashed file only needs to contain 20 million KEYS, which is a much smaller hashed file than 20 million rows, if all you're doing is checking for existence.

Why has nobody mentioned the MatchField function? To use this you set up a pattern that matches the entire string, and extract that part of the string the corresponds to the Nth element of the pattern. It's a very powerful extraction function, and - it would seem to me just glancing at the requireme...

Read the response again. It IS a solution to your question.

Or is the problem that legendkiller has not done a thorough enough search in the environment variables in the Administrator client?

My reading - if your transcription is correct - is that you need to pass 75 out of 79. There is no % sign anywhere in what you posted.

If the question really is a server question, the answer is one.

Please post the script that is performing the FTP task from s2 to s3. The problem is somewhere in that script.

It's the actual expression that is too long. You need to create the same logic in a routine, and invoke that. Or to break up the long expression into a number of smaller ones, storing the intermediate results in stage variables, and logically combine the results there. I have created jobs that teste...

Check the operating system permissions on DS_AUDIT and DS_AUDIT/DATA.30 to see whether you are permitted to write. If not, get yourself placed into the group that does have write permission.