server jobs

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

Post Reply
sunitha_cts
Participant
Posts: 98
Joined: Thu Feb 05, 2009 1:14 am
Location: visakhapatnam
Contact:

server jobs

Post by sunitha_cts »

HI,
I have 2 flat files say read f1 and f2 ,read f1 names file and check if name stem (first 4 characters of name )is present in f2 names stem file flat file.I f found update sequence number else add new name stem with sequence number, increment sequence number or all records in f2 by 1. HOW CAN I IMPLEMEN THIS ?

Kindly give a solution to this problem

Thanks
Sunitha
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Still not a doing a very good job of choosing post titles. :?

I honestly cannot follow your description. Can we try again please, rephrase your requirements and (ideally) include some examples of the contents of these two flat files?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Load f2 into a hashed file. Use NameStem as the key.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply