DSXchange

No, you invoke ExecSH to execute a command pipeline that includes the test. You don't need to conditionaly call ExecSH. Hence the commands I mentioned. Something like

Reject stupid requirements!

After all, if you use ExecSH as your after job subroutine, then what's in the Input Value field (head, cut, test and touch commands) is effectively a UNIX script. Or do they want the whole thing written in DataStage BASIC (which is certainly doable)?

In both cases try setting the quote character to 000.

Please mark thread as Resolved

alkanti wrote:Can the modify stage be used to concatenate a constant value to a varchar column? or the constant has to be defined as a separate column and then do the concatenation.

No. Modify stage functions are single-argument functions. That rules out arithmetic operations.

If you like, but it may be sufficient to fix the INCLUDE environment variable.

There's nothing to change the sort order when you're partitioning. Every separate node will be correctly sorted. Should you ever need to bring the data back to sequential processing, make sure that you specify Sort/Merge as the collection algorithm, and base it on the sort keys.

Why can't you use server job? It's the right tool for the task.

Then use a BASIC Transformer stage in your parallel job.

U did not provide any help.

The second person personal pronoun in English is spelled "you", not "u".

How?

No, don't ask. Demand to know.

Converting to comma delimited seems to be a good workaround.

I don't have the chance to experiment - tight timeline on current project.

Enterprise stage, Before/SQL or After/SQL (Open or Close command).

You can always open the compiled help module (*.chm file) in the C:\IBM\InformationServer\Clients\Classic folder on the client machine.
DSDesign.chm for Designer, for example.

But it's nowhere as useful as the pre-version 8 help - my favourite portals (like "BASIC Tasks") seem to have gone.

Precisely that question has been asked - and answered - previously.

Perhaps you are facing the same interviewer?

Search