DSXchange

You can provide the tr function in the filter options of your sequential file stage. You dont need to redirect it to a new file. Thanks for the replies! Unfortunately, in some cases, sequential stage is not an option. I read the other post suggesting the trim function, do you know what to put as th...

Does anyone know how to remove special characters (Newline character, Carriage return character, etc.) in parallel jobs?
These are unprintable characters, I know there is ICONV function for server jobs, is there any function similar to that in parallel jobs?

Any help is appreciated.

Grace

Thank you very much for all your responses, that was very helpful. I did notice that we have a "Failed to connect JobMonApp on port" error, and after I restart the JobMonApp, I am able to retrieve the rowcount being passed down to the link, so this solved one of the mysteries. But now back...

Can you please explain how to turn on the monitor?

I just realized that even I can get the rowcount from the link, it won't serve the project needs. What we are trying to do is that get the actual rowcount that being inserted/updated/deleted in the table, the count from the link is what being passed down. So I am thinking to get the rowcount from th...

Not sure what's the difference between the passive stage name & the active stage name.
Can you explain it?

Thank you for all your response! Yes, the DSJ.ME is valid in an afterjob routine. But I am still not get any rowcount back, even when I tried to write the job report out to a file using the statement below: ReportText =DSMakeJobReport(JobHandle,2,"CRLF") I can see the job/stages/links name...

Thanks a lot for your quick response!!

I am using JobHandle = DSJ.ME, so there is no need for DSAttach(), right? The stageName & LinkNames are valid.

I am trying to get the rowcount by using JobRowCount = DSGetLinkInfo(JobHandle,StageName,LinkName,DSJ.LINKROWCOUNT ) in an after job subroutine , but it always returns zero while I can see from the log that there are rows being processed, I saw many people get a good result by using the DSGetLinkInf...