In 8.7 Server Edition we have created a routine that will evaluate strings for blanks, nulls, or empty and return blank. This routine works fine in 8.7, but now working in 9.1 Parallel Edition I'm wondering if there is a function or pre-existing routine that does this?
Is there a way to access this server routine (in BASIC)? Do I need to re-write the routine as a parallel routine (in C)? More importantly, is there functionality built into the Parallel Edition that I'm missing? I'm not seeing any, but want to be sure.
Thanks!
Converting Empty Strings to Blank - Server to Parallel Eds
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are lots of solutions but, without knowing your exact requirement/logic, we cannot comment on whether an out-of-the-box solution exists.
You can call BASIC routines from the BASIC Transformer stage in parallel jobs.
You can use server jobs.
You can rewrite the logic into a parallel routine.
You can call BASIC routines from the BASIC Transformer stage in parallel jobs.
You can use server jobs.
You can rewrite the logic into a parallel routine.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Good Morning, Ray.
Thanks for the response.
Essentially, we want to evaluate strings and provide blank when there is no data. Usually Nulls are desired, but we have several clients that prefer blank which is why we wrote this routine.
We could do it with a series of statements in the transformer, but obviously it's easier for maintenance in one routine.
Our team is hoping to take advantage of being in the parallel edition. Would we lose any efficiency/processing by using a BASIC Transformer stage in our parallel jobs? Would it make more sense to write a parallel routine (which needs to be in C, correct?)
Thanks!
Thanks for the response.
Essentially, we want to evaluate strings and provide blank when there is no data. Usually Nulls are desired, but we have several clients that prefer blank which is why we wrote this routine.
We could do it with a series of statements in the transformer, but obviously it's easier for maintenance in one routine.
Our team is hoping to take advantage of being in the parallel edition. Would we lose any efficiency/processing by using a BASIC Transformer stage in our parallel jobs? Would it make more sense to write a parallel routine (which needs to be in C, correct?)
Thanks!