DSXchange

Is the DataStage RPC daemon (dsrpcd) running on your DataStage server machine?

Truncate is a non-transactional operation that is very fast. As Craig notes, it occurs first and is irreversible.

Welcome aboard.

This question has been addressed in the past; you can use Search to track it down. Essentially, though, the easiest way is to define another, temporary, MQ series queue and move the messages to that from the input queue.

Fmt() is a BASIC function and thus not available in parallel Transformer stage. As Arnd says, integers do not have leading zeroes; they are stored internally in binary format. Therefore, if you need leading zeroes, you also need an appropriate data type (a string of some kind). But ask yourself whet...

Is this for parallel job (as your job type is marked) or for server job (as per the forum in which the question is posted)?

vinita@hsbc wrote:First i have to check whether the file is there in Directory or not.

What else do you have to do?

If you use environment variables as job parameters, set the job parameter default value to the special value $PROJDEF so that its value is picked up from what was defined in the execution project's Administrator client.

Derive each of the output columns as something like
I am assuming here that Stu is a field name, even though you used the word "type".

I think you need to read the manuals that come with the SAP R/3 Load PACK. Most of us don't have these manuals.

Do you have a reject link on your Sequential File stage - the one that reads the file?

None at all, because you have provided too little information. What is your job design?

VOC is a database table in the Repository database that contains the vocabulary (all the command names, routine names, table names and so on) used in that project. Each project has a separate VOC. Q-pointers are a way of referring to a table in a different project. They are not, in general, used in ...

Not unless you want to process a different character set or locale.

Import the SQL Server table definition and use whatever is imported.

You can only pass them through InputArg, separated by some delimiter character (space will do). You then parse InputArg in your routine and call DSGetLinkInfo() as many times as there are links named in InputArg.