DSXchange

1. Use INDEX('0123456','0123',1)
2. Use CONVERT(',','.','123,456')
3. No interactive line-by-line debugger in PX. Debugging needs to be done via other means.

suresh_dsx wrote:i...if i give normally like (sh two.sh) it is working fine...

But that isn't what you are calling from DataStage. What if you issue the exact same command? ?

Good one - from someone who is, occasionally, guilty of the same transgression.

Recall that there were 2 steps involved. The first was sorting.

What happens if you issue your command "ksh /home/noones/sh two.sh" manually from a shell. Should be the same error you are seeing in DS? Perhaps your DataStage user doesn't have rx access to the executable "/home/noones/sh"?

The machine name is used in the UV.ACCOUNT file and in the schema; when the machine name changes the license validation stops working and you need to re-install.

But DataStage doesn't have this functionality of doing a wildcard lookup on a directory's files, you need to get that information from UNIX using DSExecute or a similar type of call. So there is no conversion, in the sense that you are looking for, possible.

No, I won't give that syntax as it is described in the documentation I noted earlier. If you aren't will to read and give it a try (or even to search this forum for code snippets) then I'm not willing to invest time in doing it for you. If you'd actually tried something and it didn't work and posted...

Odd, I entered "Preserve Partitioning" and "search for all terms" and got 42 hits, many of which are helpful. Perhaps you might try searching again.

You can use the link partitioner to do this in the same job. Make sure that you do specify the job properties, Performance Tab, "Row Buffer -> Interprocess" so that these are all fired off as separate processes at runtime.

DataStage BASIC code is not shell script. The function "[ ! -f ${File_Name}]" will not work. You need to get the file list matching that pattern using a different method. How you do this depends upon where you are coding this.
Please look at the BASIC handbook and search for the function "DSExecute"

this is not a FAQ and doesn't belong in this forum. It is a Parallel job question and should have been posted there.

DataStage PX 7.5.2 does not need a C++ compiler, it requires the "MS .NET 2003 C++ compiler " that is part of the Visual Studio software.

suresh_dsx wrote:If [ ! -f ${File_Name}] Then...

This is not DataStage BASIC syntax. The answer depends upon how you are getting a value for "File_Name" in the program.

you could load one of the flat files to a hashed file using the keys you want to join on, and then use a transform stage with a lookup to perform your join.

Satish,

that solution will not work with flat files in DataStage Server. Try it and see.