DSXchange

I can't use funnel because the transformer and seq file are put up in a parallel shared container which is used couple of times in a single parallel job. Instead of writing to the sequential file within the shared container, send the rows to the container's output, then funnel those outputs from th...

tminelgin wrote:Why not funnel each link together and then write them?

I can't use funnel because the transformer and seq file are put up in a parallel shared container which is used couple of times in a single parallel job.

Hi,
This might be very stupid question but I am unable to figure why sequential file is reading a decimal filed value of zero as null. This is causing issues in my development logic. Please guide!

But I am able to get all the records in the file using the External Target Stage. I think it may be due to the fact that a separate unix process redirects the data to a file in external target stage.

Thanks Ray! I could get the expected result using the external target stage specific program in the required format (awk '{print}' >> /tmp/datafile).

Would this be an issue?

That clarifies the missing records, thank you Arnd & Chulett!!! But, now the question is what should I use to mimic hash file behavior in parallel jobs provided my requirement remains same? I tried using dataset but that is not allowed as well. I can think of using server shared container if and...

Ray,
I was able to get the expected result by adding the APT_EXECUTION_MODE=One process and APT_DISABLE_COMBINATION=TRUE but this would take any medium complex job to run forver. Please advice the alternatives.

Sorry Ray, I just moved it to Parallel forum.

Hello Everyone, I am trying to write two sets of data containg 5 records each to the same sequential file in an APPEND mode after the tranformations in a parallel job. But, my sequential file contains only 5 records after the job runs even though log shows that 5 records are consumed by each of the ...

Hello Everyone, I am trying to write two sets of data containg 5 records each to the same sequential file in an APPEND mode after the tranformations in a parallel job. But, my sequential file contains only 5 records after the job runs even though log shows that 5 records are consumed by each of the ...

Hello Ray, I do not have access to restart the engine to see if it really loads when we start the DataStage server. But I was under assumption that NLS maps are shown in administrator/designer if & only if they are loaded when DataStage starts OR I do not completely understand what you intend to...

Hi Rai,
Did you get the solution for this issue by any chance or you had the tables changed from nvarchar to varchar?

Thank you Ray/Duke!

Thanks to everyone for the replies! This is also stored in the job design. I would imagine you would need to recompile the job even if you changed all the correct places. I would not recommend changing these directly. Why are you not using Designer? To answer your question Duke, we do not have compi...

Hi, I have jobs in production with multiple instance flag disabled and I need to enable it using UV commands. I know that below query provides me the flag status in the DS job executable file. I would like to know the syntax to update the RT_CONFIGxx so that the flag can be switched to "1"...