DSXchange

Is there a subdirectory called "pipe" in your project?

Webservice wasn't mentioned in the original question.

I did not suggest using a shell script as a wrapper to the job - I suggested using a shell script to execute sqlplus to call the stored procedures from DataStage. This should still be a valid approach in an SOA environment.

OP is on Windows, but maybe has MKS Toolkit or similar.

On Windows open a cmd shell and invoke ftp. When the ftp> prompt appears type in a single ? or the word help to get a list of help topics.

1) DataStage jobs exposed as web services don't need any wrapper.
2) See previous answer.
3) Typically you set up the DataStage job to receive and return small XML documents when exposing it as a web service.

I think Arnd means Seq() rather than Char(). Is Seq() available in parallel jobs?

Set up a shell script to invoke sqlplus (search the forum for techniques). You can then invoke this script from the master control job sequence or from any other job sequence (via an Execute Command activity) or even from a before-job subroutine invoking ExecSH.

It was always being captured. You just weren't looking at it all.

You can capture the result of the ls command using backquotes, and use that as the first argument of the mv command that renames (or copies) the file prior to its being transferred.

Learn FTP.

More stage variables! You might also consider pre-loading a hashed file with the Max Date for each Number to make the comparison easier.

It would depend upon how you implemented the lookups, information that you have chosen not to provide. It is possible to achieve the same results with lookup as with join, provided that certain conditions are met.

The date format string must match the date format.
"%yyyy-%mm-%dd" matches "1995-03-01" but does not match "19950301".
"%yyyy%mm%dd" matches "19950301" but does not match "1995-03-01".

Try it and let us know.

The first three roles correspond exactly with their pre-8.0 counterparts. Roles are associated with operating system groups pre-8.0, not with user IDs. UNIX user ID's are completely irrelevant apart from logging in to the server; it's all managed through IIS user IDs in version 8.0. Super operator c...

Is the rename command correct? What message (if any) is returned and logged from it? Would you consider using some other form of remote execution?