I do have a server routine which replaces all the new line characters and some special characters which i am using for each of char and varchar fields in existing design. However server routine does not work in parallel jobs also I've not used parallel routines ever but we need to implement the same Using Parallel Job. Is there any way to do the same except using derivation in transformer stage for each column?

Of course. You really should become intimately familiar with all of the parallel functions you have at your disposal. Documented
online here.
I personally would prefer that you go through the documentation and try to solve this yourself rather than just providing the code that you would need. Teach a man to fish and all that...

But of course, make sure you come back and ask questions when you have them!

_________________-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.

Thanks craig for the pointer, However we need some generic solution like routine as we need to apply it in multiple jobs for n number of columns . I am aware that we can go for a parallel routine in C++ and use object file of that in parallel routine. Still if there is any other pointer that we can use will be more helpful.

Well... this is all IMHO and others are encouraged to chime in as well but I wouldn't head to a C++ custom routine solution for something simple like the example you posted. Save that approach for times when the function either needs to be complex or adds functionality that does not exist in what the product currently delivers.

If you need reusable logic you may want to look into Shared Containers for something like that. As with most this it... depends.

_________________-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.

Add To FavoritesView next topicView previous topic
You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot vote in polls in this forum