Sort String

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

datastager
Participant
Posts: 7
Joined: Wed Oct 10, 2007 1:03 pm

Post by datastager »

Ray thanks for taking time and explaining the code.
It is for sure a master piece.
Thanks again.

jdmiceli,
I just tried it on a small subset of data, I was pretty fast.
I will let you know the performance with larger volumes.
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

Post by jdmiceli »

Thanks, Gents!

I appreciate the replies and look forward to seeing how it works on a really large set. I'm interested because I have a similar issue on one of the teams I work with and I'm wondering how best to address it.

Bestest!
Bestest!

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

jdmiceli wrote:I'm interested because I have a similar issue on one of the teams I work with and I'm wondering how best to address it.
ray.wurlod wrote:Remember that this function is sorting a delimited list of city names for each record processed - it is not sorting the file.
Not sure why you would want to consider an external call in this situation. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

Post by jdmiceli »

Strictly due to ignorance on my part. :oops:

I'm not very familiar with routines and coding in DS Basic yet. I have yet to get something to work correctly (I'm working on one right now for a project). So, depending on the deadline I had to meet, I would sometimes have no choice but to use what I knew. I'm trying to learn to do it the 'right' way and I continue to learn from you guys here on this site.

Bestest!
Bestest!

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
Post Reply