DSXchange

I believe you haven't installed the complete package and the "g++" hasn't been installed. I'm not sure if this works with red hat: "yum install gcc-c++"

Since the same action is performed twice, it is more efficient to use a stage variable, but in this case (TRIM(to_transf4.COST_CNTR_TCD='') becomes (TRIM(NullToEmpty(to_transf4.COST_CNTR_TCD)='') That assumes that you want NULL values to equate to an empty string, otherwise the function would be (TR...

What happens if you enter "g++" from the command line?

It doesn't take care of the first occurrence, though.

Well, if that file doesn't exist then you've found your error. I can't check right now, but none of those files look like the c compiler calls that I recall seeing on AIX. In fact, a bit of Googling shows me that the call should indeed be "xlC_r". Can you search your system to see if that ...

I hope you realize that you won't be getting much in the way of constructive advice until you post your error message(s).

The documentation explains how stage triggers work, which is what you are looking for.

Although I find your problem description rather confusing, I can see that COST_CNTR_TCD is a nullable field but you perform no null handling (i.e. NullToEmpty() or NullToValue() ) and your row will be dropped.

Craig has already asked you, what happens when you enter "/usr/vacpp/bin/xlC_r" on your command line?

Could you explain your problem a bit more - is the semicolon actually your field delimiter character and is this character being placed in the last column?

If the ";" is also a field delimiter then you can either add a dummy "FILLER" field to your column definitions or you can use the "filter" in your sequential stage to remove that trailing semicolon from you data stream using something like "sed 's/[ ;]*$//'"

It can be a bit of work to get the stage working as expected. First you need to write the job, preferable with RCP, but using your normal output stage. Once you have all the stage options correctly defined as you want them, turn on $OSH_DUMP and select the section that uses the stage you want to tur...

We think that your question was answered.

Assuming an NLS setting of English.

Sorry, I just saw "Parallel" in the description and posted my previous response according to that. Now I notice that you want to do this logic in the Job Control section. So your variable "Output" is now "2012-03-23 10:11:11". In order to get your requested format I wou...